CONNECT BY

Ruslan A Dautkhanov <rusland@scn.ru> writes:

Here's the patch ( http://gppl.terminal.ru/ ), which allow
PostgreSQL use queries like
connect by id = prior parent_id

Isn't this the same patch that we rejected a year or two back?

as described in SQL standard...

AFAIK there is no such syntax in any version of the SQL standard.
The syntax that *is* there in SQL99 uses "WITH" to achieve roughly
the same results, but with much syntactic difference from Oracle.

If you'd like to submit a patch that implements spec-compatible
WITH, I can pass along some preliminary work that Andrew Overholt
did at Red Hat.

regards, tom lane