-Josh, i don't be so thrilled:), with current implementation of /contrib/tablefunc mine problem sill remains: i need to sort tree leaves in some order, independent of tree itself. this can be fixed (in tablefunc) by addition to connectby() one more field like 'order_by' or so. but it will be more difficult to scale. for ex. if i need to make subquery with connect by, with tablefunc i need to create view to do so. what if i need several different such queries? of course this can be done with tablefunc, but IMHO mine approach is a bit more 'native':)
--- .evgen On Sat, 16 Nov 2002, 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. > > Download 7.3b5 now if you can't wait; Joe would like more people to > test his module, anyway. > > -Josh Berkus > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
