Evgen Potemkin kirjutas R, 22.11.2002 kell 15:57:
> Hi there!
>
> Patch is posted to pgsql-patches. docs inside.
It would of course be nice to support both Oracle and ISO/ANSI syntaxes,
but I'm afraid that the (+) may clash with our overloadable operators
feature.
> SQL 99 version will be later.
I attach a railroad diagram of SQL99 "WITH RECURSIVE" and a diff against
mid-summer gram.y which implements half of SQL99 _syntax_ (just the WITH
{RECURSIVE} part, SEARCH (tree search order order) and CYCLE (recursion
control) clauses are missing).
WITH clause seems to be quite useful in its own right as well, not just
for recursive queries, so I guess that someone with good knwledge of
postgresql internals could get plain WITH working quite fast -
The main difference between subqueries defined in WITH clause and in
FROM clause is that while subqueries in FROM don't see each other in
their namespaces, the ones in WITH either see all preceeding ones (plain
with) or just all in WITH clause (WITH RECURSIVE)
--------------
Hannu
