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
jtesser@nbbc.edu
Eph 2:8-10
