public inbox for [email protected]
help / color / mirror / Atom feedRe: improvise callbacks in plpgsql
4+ messages / 4 participants
[nested] [flat]
* Re: improvise callbacks in plpgsql
@ 2005-11-02 13:45 Merlin Moncure <[email protected]>
2005-11-02 23:44 ` Re: [PERFORM] improvise callbacks in plpgsql Jim C. Nasby <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: Merlin Moncure @ 2005-11-02 13:45 UTC (permalink / raw)
To: Jim C. Nasby <[email protected]>; +Cc: [email protected]
> 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).
Merlin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [PERFORM] improvise callbacks in plpgsql
2005-11-02 13:45 Re: improvise callbacks in plpgsql Merlin Moncure <[email protected]>
@ 2005-11-02 23:44 ` Jim C. Nasby <[email protected]>
2005-11-03 02:52 ` Re: [PERFORM] improvise callbacks in plpgsql David Fetter <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: Jim C. Nasby @ 2005-11-02 23:44 UTC (permalink / raw)
To: Merlin Moncure <[email protected]>; +Cc: pgsql-www
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).
>
> Merlin
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
--
Jim C. Nasby, Sr. Engineering Consultant [email protected]
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [PERFORM] improvise callbacks in plpgsql
2005-11-02 13:45 Re: improvise callbacks in plpgsql Merlin Moncure <[email protected]>
2005-11-02 23:44 ` Re: [PERFORM] improvise callbacks in plpgsql Jim C. Nasby <[email protected]>
@ 2005-11-03 02:52 ` David Fetter <[email protected]>
2005-11-03 14:01 ` Re: [PERFORM] improvise callbacks in plpgsql Merlin Moncure <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: David Fetter @ 2005-11-03 02:52 UTC (permalink / raw)
To: Jim C. Nasby <[email protected]>; +Cc: Merlin Moncure <[email protected]>; 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 [email protected] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [PERFORM] improvise callbacks in plpgsql
2005-11-02 13:45 Re: improvise callbacks in plpgsql Merlin Moncure <[email protected]>
2005-11-02 23:44 ` Re: [PERFORM] improvise callbacks in plpgsql Jim C. Nasby <[email protected]>
2005-11-03 02:52 ` Re: [PERFORM] improvise callbacks in plpgsql David Fetter <[email protected]>
@ 2005-11-03 14:01 ` Merlin Moncure <[email protected]>
0 siblings, 0 replies; 4+ messages in thread
From: Merlin Moncure @ 2005-11-03 14:01 UTC (permalink / raw)
To: David Fetter <[email protected]>; +Cc: pgsql-www; [email protected]
On 11/2/05, David Fetter <[email protected]> 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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-11-03 14:01 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-11-02 13:45 Re: improvise callbacks in plpgsql Merlin Moncure <[email protected]>
2005-11-02 23:44 ` Jim C. Nasby <[email protected]>
2005-11-03 02:52 ` David Fetter <[email protected]>
2005-11-03 14:01 ` Merlin Moncure <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox