Adam Witney <awitney@xxxxxxxxxx> 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
