Re: Cool PL/PgSQL hack :)

Joe Conway has put up several interesting array processing functions.
Two of them are in General Bits: Issue 24 article 6 (appending
to an array) and issue 27 article 6 (Loop over an array).

http://www.varlena.com/GeneralBits/archive.php

Your approaches are pretty similar.

elein

On Thursday 29 May 2003 17:58, David Fetter wrote:
> On Thu, May 29, 2003 at 04:34:09PM -0700, Sean Chittenden wrote:
> > > Kind people,
>
> > > Here's a little hack I put together that looks a lot like Perl's
> > > join() operator. Comments, suggestions for improvement, and
> > > sources for old-school pizzelle irons are all welcome :)
>
> > For the hyper performance sensitive, use := instead of SELECT INTO.
>
> Thanks!
>
> BTW, I'm doing a few similar things like a string_split that returns
> an array, and eventually--don't know quite how hard this is--similar
> operations with one-column SELECTs instead of arrays. Am I
> reinventing the wheel here?
>
> > That said, I'm slowly moving things over to compiled .so's which is
> > significantly faster, but this had me wondering: has anyone done any
> > comparative benchmarks of the various pl languages for PostgreSQL?
>
> Hmm...got source?
>
> Cheers,
> D
> --
> David Fetter david(at)fetter(dot)org http://fetter.org/
> phone: +1 510 893 6100 cell: +1 415 235 3778
>
>

--
=============================================================
elein(at)varlena(dot)com Database Consulting www.varlena.com
PostgreSQL General Bits http:/www.varlena.com/GeneralBits/
"Free your mind the rest will follow" -- en vogue