Skip site navigation (1) Skip section navigation (2)

Re: Cool PL/PgSQL hack :)

From: elein <elein(at)varlena(dot)com>
To: David Fetter <david(at)fetter(dot)org>,SF Postgres <sfpug(at)postgresql(dot)org>
Subject: Re: Cool PL/PgSQL hack :)
Date: 2003-05-30 01:19:10
Message-ID: 200305291819.10595.elein@varlena.com (view raw or flat)
Thread:
Lists: sfpug
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


In response to

sfpug by date

Next:From: Josh BerkusDate: 2003-05-30 03:52:14
Subject: Re: Cool PL/PgSQL hack :)
Previous:From: David FetterDate: 2003-05-30 00:58:48
Subject: Re: Cool PL/PgSQL hack :)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group