Philippe Lang, 13.07.2009 08:05:
Hi,
Now that Postgresql 8.4 has a "WITH RECURSIVE" operator (thanks! :)), is
there a chance we can see one day "START WITH... CONNECT BY" in
Postgresql, or is that something 100% oracle-specific?
START WITH is Oracle specific whereas recursive CTEs are an ANSI Standard (supported by PostgreSQL, Firebird and SQL Server).
As far as I can tell anything you can do with CONNECT BY can be done with WITH RECURSIVE
(including ORDER SIBLINGS BY), it's just a bit more "noise" because you need to
write more stuff (I wish the ANSI standard had adopted the CONNECT BY, it's really very
elegant)
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
