[GENERAL] Question about stored procedures

2005-10-13 Thread Josephine E. de Castro
Hi everyone,    I just want to know if there is an equivalent method in PostgreSQL that acts like SQL Server's extended stored procedure. I want to run a stored procedure that can update a file in the file system..  I dont know whether I can do this using PL/pgSQL or do i need to use another metho

Re: [GENERAL] Question about stored procedures

2005-10-13 Thread Josephine E. de Castro
Hi Sean!  Thanks for your reply. :)   My knowledge of PL/Perl is limited and confined to knowing that such language exist.    Is there no 'trusted' way of doing this? How about creating a trigger using C? Or should i stick with something like PL/pgSQL and look for its 'untrusted' flavors?   Anywa

Re: [GENERAL] Question about stored procedures

2005-10-13 Thread Josephine E. de Castro
Thanks Andreas!   I will try yours and Sean's suggestions and see where it will take me! :)   I've got some learning to do and I'm really grateful for the replies that I got from this group!   Again, my utmost gratitude!   :) "A. Kretschmer" <[EMAIL PROTECTED]> wrote: PL/pgsql i a trusted language