Adam Witney <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
