Обсуждение: returning more than one value from pgsql

Поиск
Список
Период
Сортировка

returning more than one value from pgsql

От
qradius@qnet.com.pe
Дата:
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



Re: returning more than one value from pgsql

От
"Geoffrey J. Gowey"
Дата:
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:

>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)
>