X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 41952D82EB for ; Wed, 2 Nov 2005 09:45:06 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 53344-10 for ; Wed, 2 Nov 2005 13:45:00 +0000 (GMT) Received: from Herge.rcsinc.local (mail.rcsonline.com [70.89.208.142]) by svr1.postgresql.org (Postfix) with ESMTP id D8893D7D49 for ; Wed, 2 Nov 2005 09:44:59 -0400 (AST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: Re: improvise callbacks in plpgsql Date: Wed, 2 Nov 2005 08:45:02 -0500 Message-ID: <6EE64EF3AB31D5448D0007DD34EEB3417DD76D@Herge.rcsinc.local> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [PERFORM] improvise callbacks in plpgsql Thread-Index: AcXfOKRHuQpQ7RcvTMmXKhyC8N16PgAd8XWA From: "Merlin Moncure" To: "Jim C. Nasby" Cc: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.046 required=5 tests=[AWL=0.046] X-Spam-Score: 0.046 X-Spam-Level: X-Archive-Number: 200511/26 X-Sequence-Number: 15283 > 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). =20 Merlin