From: David Fetter <david@fetter.org>
To: Jim C. Nasby <jnasby@pervasive.com>
Cc: Merlin Moncure <merlin.moncure@rcsonline.com>
Cc: pgsql-www@postgresql.org
Subject: Re: [PERFORM] improvise callbacks in plpgsql
Date: Wed, 2 Nov 2005 18:52:33 -0800
Message-ID: <20051103025233.GG29465@fetter.org> (raw)
In-Reply-To: <20051102234430.GA55520@pervasive.com>
References: <6EE64EF3AB31D5448D0007DD34EEB3417DD76D@Herge.rcsinc.local>
<20051102234430.GA55520@pervasive.com>
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@fetter.org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: david@fetter.org, jnasby@pervasive.com, merlin.moncure@rcsonline.com, pgsql-www@postgresql.org
Subject: Re: [PERFORM] improvise callbacks in plpgsql
In-Reply-To: <20051103025233.GG29465@fetter.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox