setof (more than one column)
Reinoud van Leeuwen <reinoud@xs4all.nl>
From: "Reinoud van Leeuwen" <reinoud@xs4all.nl>
To: <pgsql-hackers@postgresql.org>
Date: 2002-01-03T14:11:11Z
Lists: pgsql-hackers
Hi, I am doing some tests with functions in 7.2b4. I got some stuff to work that returns 'setof text' but I was wondering whether it is possble to let the function return more than one column, something like: create function myfunc (integer) returns setof (text, integer) or create function myfunc (integer) returns setof text, integer I've searched the docs about the syntaxt of the 'setof' keyword but could not find really much. TIA, Reinoud van Leeuwen