On Sat, Jun 04, 2005 at 11:31:02 +0200, Joachim Zobel <jzobel@xxxxxxxxxxxxxxx> wrote: > > These are both things I want to avoid. I am not trying to solve a real > world problem, I want to understand the limits of SQL. And it seems that > a plain SELECT that tells me if a path exists is not possible. However I > just read nested sets (thx for the link, Sean). Maybe a tricky > representation does it. When 'WITH' gets implemented then you should be able to do this. I think there was some recent talk about that, but I don't know if it is going to make it in to 8.1. We'll know in about a month though. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
