Re: returning more than one value from pgsql - Mailing list pgsql-general

From Geoffrey J. Gowey
Subject Re: returning more than one value from pgsql
Date
Msg-id 3BF40AF2.5010505@rxhope.com
Whole thread Raw
In response to returning more than one value from pgsql  (qradius@qnet.com.pe)
List pgsql-general
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)
>



pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: pgsql and large tables
Next
From: "Andrew G. Hammond"
Date:
Subject: Re: Bug?