Am Mit, 2003-05-21 um 10.42 schrieb Gerard TOURRES:
> I can't find an equivalent for select...connect by (sort data in a
> tree, beginning at a defined point towards 'son' or 'father').
>
> Running Psql 7.2.1 on Debian woody
This is called "WITH RECURSIVE" in SQL '99 and not yet implemented in
7.3.1
But it is possible to write a "stored procedure" (function) that does
the same thing.
http://216.239.33.100/search?q=cache:bo25WxY-5v0J:not.disenchanted.com/6008.html+select+%22connect+by%22+postgresql&hl=en&ie=UTF-8
cu
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : www.e-trolley.de