Re: Recursive queries

On Tue, Jan 25, 2005 at 08:24:54PM +0100, tmp wrote:
> > What do you mean by resursive queries? A query can have a subquery
> > which calls a function which executes another query. That counts as
> > recursion in my book. What type of recursion are you thinking of?
>
> SQL:2003 defines a language construct for recursive queries (T131 and
> T132). What I ment with the question was: Will postgresql soon support a
> similar (or the same) construct?

I don't have the SQL standard but I think you're referring to tables
that join to themselves and you want to follow these links recursively.
I don't think anybody has written the syntactic sugar, but someone did
write a function that provides equivalent output.

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.