-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Tuesday 15 October 2002 04:08, Shawn Grover wrote:
> Now, I could be wrong, I've been hearing rumors that the next version was
> supposed to support SPs, and that might be out already for all I know....
> I don't know if Postgres supports SPs or not.
yes and no.
you can store procedures in the database written in pl/pgsql (very similar to
oracle's pl/sql) and other languages (even perl, apparently =), though
pl/pgsql is the best supported and most popular.
however, they are not stored precompiled. they are compiled each time they are
run. this technically disqualifies them as "true" stored procedures in the
strictest database sense of the term.
for all intents and purposes, though, they are SPs. and i'm sure eventually
one of the clever pgsql hackers will fix the not-precompiled issue and we'll
see even more speed!
- --
Aaron J. Seigo
GPG Fingerprint: 8B8B 2209 0C6F 7C47 B1EA EE75 D6B7 2EB1 A7F1 DB43
"Everything should be made as simple as possible, but not simpler"
- Albert Einstein
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE9rHp51rcusafx20MRApOWAJ0cLhizyFeUaPjkY2PHNRGRCjHi/ACffNPf
x441nQ8/1tlnoF9olDUkjf8=
=F8lf
-----END PGP SIGNATURE-----
