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