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?
There is a commercial / proprietary version of the pg database called 'EnterpriseDB Advanced Server' that supports this.