Stephan,
> Has anyone considdered adding the START WITH and CONNECT BY functionallity
> that Oracle has. I've been developing for many years now and I find that
> almost every application we build requires some kind of hierarchical
> structure. I know there are other ways of accomplishing this in
> Postgresql, but I've always found it to be more work than using something
> simple like the Oracle START WITH/CONNECT BY clause.
From http://developer.postgresql.org/~momjian/TODO.html
* Add SQL99 WITH RECURSIVE to SELECT
.... any further discussion should go on PGSQL-SQL list.
--
Josh Berkus
Aglio Database Solutions
San Francisco