Ruslan A Dautkhanov <rusland (AT) scn (DOT) ru> writes:
Quote:
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?
Quote:
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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster