From: Merlin Moncure <mmoncure@gmail.com>
To: David Fetter <david@fetter.org>
Cc: pgsql-www@postgresql.org
Cc: jnasby@pervasive.com
Subject: Re: [PERFORM] improvise callbacks in plpgsql
Date: Thu, 3 Nov 2005 09:01:52 -0500
Message-ID: <b42b73150511030601q1da5f693h73cdc20cb24125e5@mail.gmail.com> (raw)
In-Reply-To: <20051103025233.GG29465@fetter.org>
References: <6EE64EF3AB31D5448D0007DD34EEB3417DD76D@Herge.rcsinc.local>
<20051102234430.GA55520@pervasive.com>
<20051103025233.GG29465@fetter.org>
On 11/2/05, David Fetter <david@fetter.org> wrote:
> 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?
you guys can do anything you like with it...
I'm working on part two which will build on the previous example and
show how to pass in a function to use as a callback, kind of like a
functor.
btw, the blog examples are a reduction of my own personal code which
went through a vast simplification process. I need to test it a bt
before it hits doc quality, there might be some errors lurking there.
Merlin
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: mmoncure@gmail.com, david@fetter.org, pgsql-www@postgresql.org, jnasby@pervasive.com
Subject: Re: [PERFORM] improvise callbacks in plpgsql
In-Reply-To: <b42b73150511030601q1da5f693h73cdc20cb24125e5@mail.gmail.com>
References: <6EE64EF3AB31D5448D0007DD34EEB3417DD76D@Herge.rcsinc.local> <20051102234430.GA55520@pervasive.com> <20051103025233.GG29465@fetter.org> <b42b73150511030601q1da5f693h73cdc20cb24125e5@mail.gmail.com>
* 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