> Sure, declare your result like my example: > > test=# create or replace function ab() returns setof record as $$declare r > record; begin select into r 1,2;return next r;end;$$language plpgsql;
Unfortunatly I have not the luxury of creating the record with a single SELECT command. Isn't there a way around this problem? I really do not want to try to write it as a single SELECT command. There must be a way of telling it what structure the record will have? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general