pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Problem with returning setof record 2+ messages / 2 participants [nested] [flat]
* Problem with returning setof record @ 2004-09-07 17:13 oliverp21@free.fr 0 siblings, 1 reply; 2+ messages in thread From: oliverp21@free.fr @ 2004-09-07 17:13 UTC (permalink / raw) To: pgsql-sql Hello, Here is a simple function I created for a test. create function ttt() returns setof record as ' declare r record; begin for r in select * from utilisateurs.menus loop return next r; end loop; return; end; ' language 'plpgsql'; When I try to use it, it returns to me : select ttt(); set-valued function called in context that cannot accept a set : PL/pgSQL function "ttt" line 5 at return next Anyone has an idea ? Best regards, Patrice OLIVER ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Problem with returning setof record @ 2004-09-07 17:35 Richard Huxton <dev@archonet.com> parent: oliverp21@free.fr 0 siblings, 0 replies; 2+ messages in thread From: Richard Huxton @ 2004-09-07 17:35 UTC (permalink / raw) To: oliverp21@free.fr; +Cc: pgsql-sql oliverp21@free.fr wrote: > Hello, > > Here is a simple function I created for a test. > > create function ttt() returns setof record as ' > When I try to use it, it returns to me : > > select ttt(); > set-valued function called in context that cannot accept a set > : PL/pgSQL function "ttt" line 5 at return next > > Anyone has an idea ? You need to treat it like a table: SELECT * FROM ttt(); Also, I'm not sure you can return a setof anonymous record types (unless you can specify the structure in the select). Try CREATE FUNCTION...RETURNS SETOF utilisateurs.menus If there's no appropriate table you can use CREATE TYPE to create a structure. -- Richard Huxton Archonet Ltd ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-09-07 17:35 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2004-09-07 17:13 Problem with returning setof record oliverp21@free.fr 2004-09-07 17:35 ` Richard Huxton <dev@archonet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox