Re: Multiple Return Values? - Mailing list pgsql-novice

From Josh Berkus
Subject Re: Multiple Return Values?
Date
Msg-id 200302171600.29510.josh@agliodbs.com
Whole thread Raw
In response to Multiple Return Values?  (Steve_Miller@sil.org)
List pgsql-novice
Steve,

> We are in the process of converting a SQL Server database to PostgreSQL.
> SQL Server stored procedures can have output parameters, as well as a
> return value. Postgres, as far as I can tell, doesn't have output
> parameters. Anybody have a good workaround for returning multiple values
> out of Postgres?

Yes.  If you're using 7.3, then you can return your output values as a faux
record, as many as you want.

If you're running 7.2, then you can return stuff as a string with delimiters,
and parse it on the client end.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


pgsql-novice by date:

Previous
From: Steve_Miller@sil.org
Date:
Subject: Multiple Return Values?
Next
From: Josh Berkus
Date:
Subject: Re: Re Dynamic IP - pg_hba