The "CONNECT BY" patch was refused by the PostgreSQL team for a more flexible, standards-compliant solution. Tom Lane says the Red Hat DB team (which he's a member of) has committed to add the functionality to 7.4.
http://archives.postgresql.org/pgsql-patches/2002-12/msg00036.php
-Roberto