> 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
nextr;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?
