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

Re: Cool PL/PgSQL hack :)

From: David Fetter <david(at)fetter(dot)org>
To: SF Postgres <sfpug(at)postgresql(dot)org>
Subject: Re: Cool PL/PgSQL hack :)
Date: 2003-05-30 00:58:48
Message-ID: (view raw, whole thread or download thread mbox)
Lists: sfpug
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.


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? source?

David Fetter david(at)fetter(dot)org
phone: +1 510 893 6100    cell: +1 415 235 3778

In response to


sfpug by date

Next:From: eleinDate: 2003-05-30 01:19:10
Subject: Re: Cool PL/PgSQL hack :)
Previous:From: Sean ChittendenDate: 2003-05-29 23:34:09
Subject: Re: Cool PL/PgSQL hack :)

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