Re: improvise callbacks in plpgsql

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: improvise callbacks in plpgsql
Date: 2005-11-02 13:45:02
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3417DD76D@Herge.rcsinc.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance pgsql-www

> 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Magnus Hagander 2005-11-02 13:54:14 Re: insert performance for win32
Previous Message Merlin Moncure 2005-11-02 13:36:57 Re: insert performance for win32

Browse pgsql-www by date

  From Date Subject
Next Message Jim C. Nasby 2005-11-02 23:44:30 Re: [PERFORM] improvise callbacks in plpgsql
Previous Message Dave Page 2005-11-01 21:27:36 Re: no win32 rc1 binaries