Re: http://www.postgresql.org/docs/8.0/static/xfunc-sql.html

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