Click to See Complete Forum and Search --> : PL/PGSQL Help


SkyHigh
03-23-2001, 09:20 AM
I have just installed PostgreSQL 7.0.3 to use in some development I am trying.

Installed and created the tables OK, but I can't find any reference documentation for PL/pgSQL. Does anybody kno of a good link to some documentation?

Failing that, can someone answer the following question:
How do I return multiple columns from a PL/pgSQL function. I can return a single column OK using the RETURNS clause in CREATE FUNCTION, but can't figure out how to return multiple columns (and multiple records with multiple columns).

Any help appreciated.

SkyHigh

SkyHigh
03-26-2001, 07:24 AM
Haven't had any replies to my pleas for help yet, so I am beginning to wonder if this means that nobody uses PL/pgSQL?

If this is the case, what do you guys use for database development?

SkyHigh

stiles
03-26-2001, 10:59 AM
http://www.brasileiro.net/postgres/
http://www.postgresql.org/users-lounge/docs/7.0/user/c4087.htm
http://www.postgresql.org/docs/aw_pgsql_book/node200.html