On Tue, May 17, 2005 at 11:24:19PM +0300, Hannu Krosing wrote: > On T, 2005-05-17 at 11:22 -0400, Tom Lane wrote: > > Hannu Krosing <[EMAIL PROTECTED]> writes: > > > On T, 2005-05-17 at 00:42 -0400, Tom Lane wrote: > > >> I seem to recall some discussion of how to do this in the past; > > >> have you trolled the pghackers archives? > > > > > I think that Jasons inspiration for doing it came from the the fact that > > > there are already now abandoned patches for doing it. > > > > Having looked over the latest patch, my advice would be to ignore it :-( > > It's almost completely devoid of documentation, except for comments > > that he copied-and-pasted from elsewhere without modification. Wrong > > comments are even worse than none. > > ANd even worse - this is from the README on the website: > > ----8<---------8<---------8<---------8<---------8<---------8<---------8<----- > WHAT'S THIS > > This is a patch which allows PgSQL to make hierarchical queries a la > Oracle do. > > (c) Evgen Potemkin 2003,2004, < gppl at inbox dot ru >, entirely based > on PostgreSQL (http://www.postgresql.org) > Patch itself distributed under GPL. No warranty of any kind is given, > use it at your own risk.
It's the notes on the CONNECT BY patch, not the WITH patch. The WITH patch, as far as I can tell, is in the public domain. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match