Re: Question about function

On Wed, 13 Mar 2002, Bruno Lopes wrote:

> Hello list.
> That might sound very lame but I am new to postgres.
> I was looking into the postgres guide and trying to make a function to make an insert to a table.
> but postgres returns me an error in the RETURN of the function
>
> query is:
> CREATE FUNCTION test() RETURNS bool AS 'INSERT INTO b (nome) VALUES (\'PQP\');' LANGUAGE 'sql';
> >> function declared to return type bool, but final query is not a retrieve
>
> obviously my return type is incorrect... so what should I use?

I think you need to end an sql language function with a select of some
sort (even if it's just say select true;)