On Thursday 27 February 2003 12:25, Roberto de Amorim wrote:
> I looked at
> http://developer.postgresql.org/docs/postgres/plpgsql-examples.html
> but there is not an example of function returning more then 1 value...
>
> could anyone sand me an example of function returning more then 1 value
> using PLPGSQL ? please
>
You can't return more than one return value from function, but that
value can be of composite type.For example :"setof text" or "setof record" are
such types.
See:
http://developer.postgresql.org/docs/postgres/plpgsql-control-structures.html
http://developer.postgresql.org/docs/postgres/xfunc.html
Regards !