Joe, i've made it already,as send first 'Proposal ...' message, but found a small bug. within nearest days i'll fix it, and post the patch to pgsql-patches. i've described why i can't use connectby() in message to Josh Berkus. i'll enhance CONNECT BY as clause, but not as function. i think it's more 'right' approach to make it:)
regards, --- .evgen On Sat, 16 Nov 2002, Joe Conway wrote: > Josh Berkus wrote: > > Evgren, > > > > > >>I want to propose the patch for adding the hierarchical queries > >>posibility. > >>It allows to construct queries a la Oracle for ex: > >>SELECT a,b FROM t CONNECT BY a PRIOR b START WITH cond; > > > > > > You'll be thrilled to know that this has already been implemented in > > PostgreSQL 7.3, as a /contrib module, by Joe Conway. > > > I have it on my personal TODO to approach this for 7.4, but I'll be happy to > focus on other things if you'd like to take this on. The connectby() function > in contrib/tablefunc could be a good starting point for you. > > Joe ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
