Can this return multiples? I thought when you dfined columns dynamically like your example it only returns one record and I need to be able to return a set. Can your example return a set?
On Thursday 30 June 2005 10:58 am, Sven Willenberger wrote: > If I understand the new features correctly, rather than: > CREATE FUNCTION foo(i int) RETURNS custom_type AS .... > and custom_type is (int,text,text) > you will be able to do the following instead: > CREATE FUNCTION foo(IN i int, OUT x int, OUT y text, OUT z text) AS ... > > As far as hard coding the OUT datatypes, if I understand the docs > correctly you can even: > CREATE FUNCTION foo(IN i int, OUT x anyelement, OUT y anyelement, OUT z > anyelement) AS ... > > No custom type needed .. you specify how the output format in the > argument section itself. > > Sven -- Jason Tesser Developer for NMI [EMAIL PROTECTED] Eph 2:8-10 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
