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