Re: returning more than one value from pgsql

The only way around this is either to make the output of the pgsql sp in
XML or make a seperator char that can be filtered. At least that's the
only two solutions that I have found.

Geoff

qradius(at)qnet(dot)com(dot)pe wrote:

>Dear Sirs:
>
>Please I would want to know any possible solution for this:
>
>Actually I am transporting my database on Sybase (Adaptive
>Server) to postgresql , but I am facing a problem :
>
>I need to trasnport a stored procedure that retruns two values
>, but I know pgsql funtions only returns 1 value, Somebody has
>experienced this situation, and how solved this?
>
>Please I am looking for ideas, its possible return a RECORD
>type ? how?
>
>Thank you for your replies in advance.
>
>Regards
>
>Ernesto
>Freyre
>
>---------------------------------------------
>Este mensaje fue enviado a travs de Qnet
>http://www.qnet.com.pe
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>