Re: Multiple Return Values?

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


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html