Joshua D. Drake wrote:
I know both. :-).
Seriously - I'd like to raise my voice in favor of installing plpgsql in template1 by default. I haven't heard any good reason not to (nor even a bad reason).
If we install plPGSQL by default, we should install any other pl language that was configured at runtime by default as well. This includes plPerl, plTCL, and plPython.
Of course only if they were compiled in, but sense they are a part of the core distribution we shouldn't favor one over the other.
Personally, plpgSQL is only useful to those who are coming from Oracle. People are more likely to be comfortable with plPython or plPerl than plpgSQL.
I disagree. I know python and perl and I have never touched Oracle, but I find plpgsql to be more useful than the others. Mainly because
(1) It is strongly typed, has all the same types as postgresql itself, consistent support for NULLS, etc.
(2) Upon a casual read of the docs I couldn't figure out how to read any values from the database other than what was passed into the pl{perl|python|php} function. I.e., how do you run a select? What client libraries do you use? Maybe the others just need better docs.
Paul Tillotson
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
