Re: Function example returning more then 1 value

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 !