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
