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
