Re: Proposal of hierarchical queries, a la Oracle

Evgen,

you'd need to post your message and patch to hackers mailing list.
btw, did you try contrib/ltree module ?
regards,
   Oleg
On Fri, 15 Nov 2002, Evgen Potemkin wrote:

>
> Hi there!
>
> 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;
>
> I've seen this type of queries often made by adding a new type, which stores
> position of row in the tree. But sorting such tree are very tricky (i
> think).
>
> Patch allows result tree to be sorted, i.e. subnodes of each node will be
> sorted by ORDER BY clause.
>
> with regards, evgen
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
Regards,    Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83