Nils,
> I always thought that Pl/PgSQL functions where 'stored procedures'.
> Probably I'm wrong, but whats the difference between a Pl/PgSQL
> function
> and a stored procedure? (just curious).
Postgres functions have really expanded the concept of function, to the
point of *almost* being stored procedures. However, there are still a
few things missing:
1. Stored procedures must be able to return a rowset, possibly mutiple
rowsets.
2. Stored procedures usually accept an indefinite number of parameters.
3. Stored procedures should be capable of logging their activites.
4. Stored procedures should have access to the full range of DB control
language, includign cursors, transactions, and error handling.
Of the 4. I'm only certain that 1. is part of the SQL92 spec. Any more
authoritative opinions?
-Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology [EMAIL PROTECTED]
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
