Adam Witney <awitney(at)sgul(dot)ac(dot)uk> writes:
> Ah you want to return a record I suppose?
> CREATE TABLE test (id int, name text);
> INSERT INTO test VALUES(1, 'me');
> INSERT INTO test VALUES(2, 'you');
> CREATE FUNCTION test_func() RETURNS SETOF record AS '
> SELECT id, name FROM test;
> ' LANGUAGE SQL;
Or better, "RETURNS SETOF test", so you don't have to describe the
output record type every time you call it.
regards, tom lane