On Thu, May 15, 2008 at 02:25:36PM +0200, A B wrote: > I'm still trying to learn to write plpgsql functions, but I find the > docs a little short on examples on how to return stuff from a > function. I'm very grateful for any help on this. What exactly about the documentation isn't clear? http://www.postgresql.org/docs/8.3/static/plpgsql-control-structures.html#PLPGSQL-STATEMENTS-RETURNING > CREATE FUNCTION foo() RETURNS ???? AS > but what do I write instead of ???? Like the documentation says: SETOF sometype. > I'm nto sure here, but It seems to mee that there are two other ways > of doing case 2. How you generate the results is up to you. when you have them you either use RETURN NEXT or RETURN QUERY to return them to the caller. > 3) In the third case, I want to create the values I return by joining > many values. Something like this > CREATE FUNCTION foo() RETURNS ???? AS You can always use out parameters if you feel better about it: CREATE FUNCTION foo(col1 int4 OUT, col2 text OUT, ...) AS ... Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > Please line up in a tree and maintain the heap invariant while > boarding. Thank you for flying nlogn airlines.
Attachment:
signature.asc
Description: Digital signature
