Re: PL/Perl returning multiple rows

Christopher Murtagh wrote:
> On Mon, 2003-11-10 at 21:11, Joshua D. Drake wrote:
>
>>The fact that it is pl/pgSQL? Seriously though, I think that pl/pgSQL is
>>counter intuitive to some people and those of us who are coming from say a Perl
>>background are going to be much more proficient in using pl/Perl then having
>>to learn YET another language.
>
>  Thanks for all the feedback. I've written a bunch of triggers in
> pl/pgsql and it wasn't the worst thing. The reason why I was thinking
> pl/perl is because my perl function needs to make a system call (to
> htDig actually) and extract integers from URLs that htDig give it.
>
>  I know I could write this in Perl with my eyes closed, but I'm not so
> sure how I would do this with pgSQL. Can you even make pl/pgSQL
> 'untrusted' to make syscalls?

Write a Pl/Perl function that just does the syscall, and call it from
PL/pgSQL. Similarly for complex string parsing, etc.

HTH,

Joe