returning setof from insert ? - Mailing list pgsql-general

From Laura Smith
Subject returning setof from insert ?
Date
Msg-id VTfbqJ6-qhwCDDq0TYhdA4XuNH0hsJSqMX6KOBTY-D_kxclXuEV2gwSaCQA3HTkm698pCg4V7qyTVTzEphlgfowGQEVAJvfggC9xqbJ8CZ8=@protonmail.ch
Whole thread Raw
Responses Re: returning setof from insert ?  (Magnus Hagander <magnus@hagander.net>)
Re: returning setof from insert ?  (Thomas Kellerer <shammat@gmx.net>)
List pgsql-general
Hi,

A bit of pl/pgsql writer's block going on here ...

Postgres complains "RETURN cannot have a parameter in function returning set" in relation to the below. I don't really
wantto have to "RETURNS TABLE" because that means I have to enumerate all the table columns. 

I'm sure I'm missing something simple here !

CREATE OR REPLACE FUNCTION foobar(foo text,bar text) RETURNS SETOF bar AS $$
DECLARE
v_row bar%ROWTYPE;
BEGIN
insert into bar(f,b) values(foo,bar) returning * into v_row;
return v_row;
END;
$$ language plpgsql;



pgsql-general by date:

Previous
From: Luca Ferrari
Date:
Subject: Re: pg_wal lifecycle
Next
From: Magnus Hagander
Date:
Subject: Re: returning setof from insert ?