Re: Command "connect by prior" in PostgreSQL ?

On 08.01.2007 17:24 Scott Marlowe wrote:
> On Mon, 2007-01-08 at 07:38, Leandro Repolho wrote:
>> Hello everybody,
>> In Oracle i use the command "connect by prior" and i need to use it in
>> PostgreSQL, what is the sintax?
>
> What does connect by prior do?  Reuse a connection from one db to
> another?  I don't think there's anything like that in postgresql.
>
> You might wanna tell us what an oracle command does next time, since
> many folks here aren't that familiar with Oracle.  Heck, I use oracle
> everyday and I'm not familiar with connect by prior...

It's used to retrieve hierarchical data e.g. a parent/child
relationship. The connect by operator defines the columns which define
the hierarchy.

Thomas