On 28 Feb 2002, Michael A Nachbaur wrote: > > 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.
There's a module on CPAN allowing you to do SQL from within PL SP's. -- <!-- Matt --> <:->Get a smart net</:->
