Re: Should I use PL/PGSQL or Perl/PGSQL?

On Fri, Feb 03, 2006 at 07:32:25PM -0800, Tyler MacDonald wrote:
> I've been wondering, does anybody know which is more likely to be
> installed on a postgresql server? Which is faster? I'm writting an
> application in perl that is going to need to get broad information about
> heiarchial data (how many parents, settings common on parents, etc), and I'd
> like to put that data presentation logic into the database.

Well, plpgsql has been around for a long time whereas plperl is new so
at a guess the former will be much more common. Also, plpgsql is
installed by default on many systems whereas plperl is usually an
addon.

As for speed, no comment. Developer time is generally more important
anyway.

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.