Re: connect by [prior]

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