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: 20030530005848.GE17939@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

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

In response to

Responses

Browse sfpug by date

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