>Actually, I was just reading some stuff yesterday about a "new" ansi
>standard for recursive joins called a "with statement."
SQL:1999 is 4 years old already. We might even see the next version of SQL this year.
> It's supposed to do
> the same sort of thing (though it looked more complicated) as Oracle's
> connect by...prior clause.
WITH RECURSIVE can do the same.
Oracle has CONNECT BY http://otn.oracle.com/products/oracle9i/daily/oct04.html
DB2 has WITH (but not WITH RECURSIVE) http://www7b.boulder.ibm.com/dmdd/library/techarticle/0307steinbach/0307steinbach.html
PostgreSQL has an unofficial CONNECT BY patch http://gppl.terminal.ru/
(Supposedly RedHat is working on a WITH RECURSIVE patch.)
I don't know of any other databases that implement recursive SQL without having to go to procedures/functions.
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
