Re: connect by [prior]

From: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
To: gerard(dot)tourres(at)free(dot)fr
Cc: Forum PostgreSQL <pgsql-novice(at)postgresql(dot)org>
Subject: Re: connect by [prior]
Date: 2003-05-21 11:04:35
Message-ID: 1053515075.7208.4.camel@billy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-05-21 14:32:07 Re: parse error when executing a simple plpgsql function
Previous Message Gerard TOURRES 2003-05-21 08:42:02 connect by [prior]