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;)

Bruno Lopes (Desenvolvimento) <blvieira@pcsolution.com.br> writes:

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?

It's unhappy because you're not returning anything (no final SELECT
statement).

You might consider updating to a more recent PG version; that error
message hasn't been worded that way for quite awhile.

regards, tom lane