> One thing that Pg offers that nobody else does is Perl stored procedures. > I haven't had the opportunity to try them yet, but it sounds very cool > indeed to be able to write SPs in Perl. Has anyone here used those yet?
I've toyed with them a bit, but for security purposes, the verison of perl that is linked in with Pg cannot access external files or system calls. As a result, you can't "require" or "use" any external libraries. Also, another real bummer, is you can't actually invoke any SQL queries from within a perl stored procedure. All you can do is things like regex's and other stuff on your input arguments. That really is too bad, considering I'd much rather use perl end-to-end. I've seen some people out there who have hacked the perl stored procedure language to allow "use" and such, but I'm not sure how successful they were. If anyone can prove me wrong, *please*, because I'd really like to use PL/Perl. -- -man Michael A Nachbaur PGP Public Key at http://www.nachbaur.com/pgpkey.asc PGP Key fingerprint = 83DC 7C3A 3084 6A21 9A3F 801E D974 AFB4 BFD7 2B6F
signature.asc
Description: This is a digitally signed message part
