Re: [PERFORM] plperl vs plpgsql

2005-04-17 Thread Alex
Is there a performance difference between the two? which of the PL is most widely used. One problem i have with the plpgsql is that the quoting is really a pain. Christopher Browne wrote: After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Alex) belched out: i am thinking about

Re: [PERFORM] plperl vs plpgsql

2005-04-17 Thread Stefan Weiss
On 2005-04-17 14:56, Alex wrote: Is there a performance difference between the two? As Christopher already pointed out, it depends on what you want to do. If you're doing some complex string processing, it will be easier (and in some cases) faster to do in plperl, if you're mainly dealing with

Re: [PERFORM] plperl vs plpgsql

2005-04-17 Thread Joshua D. Drake
On Sun, 17 Apr 2005, Alex wrote: Is there a performance difference between the two? Hello, It depends on what you are using it for. My experience is that for some reason plPGSQL is faster when looping but other than that they should be very similar. which of the PL is most widely used. One

Re: [PERFORM] plperl vs plpgsql

2005-04-17 Thread Christopher Browne
After a long battle with technology, [EMAIL PROTECTED] (Alex), an earthling, wrote: Christopher Browne wrote: After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Alex) belched out: i am thinking about swiching to plperl as it seems to me much more flexible and easier to create

[PERFORM] plperl vs plpgsql

2005-04-15 Thread Alex
Hi, i am thinking about swiching to plperl as it seems to me much more flexible and easier to create functions. what is the recommended PL for postgres? or which one is most widely used / most popular? is there a performance difference between plpgsql and plperl ? porting to other systems is

Re: [PERFORM] plperl vs plpgsql

2005-04-15 Thread Christopher Browne
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Alex) belched out: i am thinking about swiching to plperl as it seems to me much more flexible and easier to create functions. what is the recommended PL for postgres? or which one is most widely used / most popular? is there a