returning more than one value from pgsql
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 trav�s de Qnet
http://www.qnet.com.pe
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@qnet.com.pe wrote:
Show quoted text
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@postgresql.org)