> 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