Re: connect by [prior]
От
Nabil Sayegh
Тема
Re: connect by [prior]
Дата
Msg-id
1053515075.7208.4.camel@billy
Ответ на
connect by [prior] (Gerard TOURRES)
Список
Дерево обсуждения
connect by [prior] "Gerard TOURRES" <gerard.tourres@free.fr>
Re: connect by [prior] Nabil Sayegh <postgresql@e-trolley.de>
Re: connect by [prior] Joe Conway <mail@joeconway.com>
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
В списке pgsql-novice по дате отправления
