Mladen Gogala <mgogala(at)vmsinfo(dot)com> writes:
> My question, however is the following: why is "connectby" needed at
> all?
It isn't. It's there because it was there first --- we only added WITH
in 8.4. If you can persuade your Oracle guy to convert to the
SQL-standard syntax, by all means use that instead.
regards, tom lane