Re: [PERFORM] improvise callbacks in plpgsql

From: David Fetter <david(at)fetter(dot)org>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>, pgsql-www(at)postgresql(dot)org
Subject: Re: [PERFORM] improvise callbacks in plpgsql
Date: 2005-11-03 02:52:33
Message-ID: 20051103025233.GG29465@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance pgsql-www

On Wed, Nov 02, 2005 at 05:44:30PM -0600, Jim C. Nasby wrote:
> Can we get a link to this posted somewhere? I guess on techdocs?
>
> On Wed, Nov 02, 2005 at 08:45:02AM -0500, Merlin Moncure wrote:
> > > Would you be willing to write up an example of this? We often get
> > asked
> > > about support for WITH, so I bet there's other people who would be
> > very
> > > interested in what you've got.
> >
> > Sure. In fact, I had already decided this to be the next topic on
> > my blog. I'm assuming you are asking about tools to deal with
> > recursive sets in postgresql. A plpgsql solution is extremely
> > fast, tight, and easy if you do it right...Tom's latest
> > suggestions (I have to flesh this out some more) provide the
> > missing piece puzzle to make it really tight from a classic
> > programming perspective. I don't miss the recursive query syntax
> > at all...IMO it's pretty much a hack anyways (to SQL).

This might be worth putting in the docs somewhere. Tutorial?

Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Lamb 2005-11-03 05:13:11 Sorted union
Previous Message Jim C. Nasby 2005-11-02 23:50:12 Re: Trigger Rowsets

Browse pgsql-www by date

  From Date Subject
Next Message Dave Page 2005-11-03 08:13:56 Re: Presskits for 8.1 Release
Previous Message Josh Berkus 2005-11-03 01:01:44 Presskits for 8.1 Release