Hello you have to specify column names and column types. Like postgres=# create or replace function foog() returns setof record as $$ declare r record; begin r := row(10,20); return next r ; return; end; $$ language plpgsql; postgres=# select * from foog() t(a int, b int); a | b ----+---- 10 | 20 (1 row) Regards Pavel Stehule 2007/7/17, Zlatko Matić <zlatko.matic1@xxxxxxxxxxx>:
I have a plpgsql function that returns dataset. First it was defined to return SETOF someview. Then I changed it to return SETOF RECORD, in order to be able to return dataset with varying number of columns. But, I get the following error:"ERROR: a column definition list is required for functions returning "record" SQL state: 42601". What does it mean? What is "columns definition list"? Thanks, Zlatko
