Re: recursive subquery

> I have a table with records that have a hierarchical relationship with one
> another.  Some records are children of other records which in turn can be
> children of higher level records and so on until the highest level records
> are reached.  This is a simple tree relationship.  It's being represented
> by a second table with holds parentid-childid tuples so that to find the
> children of a particular parent one only has to scan the second table's
> first field for that given parent's id.
> ...

I think you hae several solutions : this is the emulation of the connect by oracle solution. You could try these links
foundat http://archives.postgresql.org/pgsql-sql/2001-11/msg00438.php  

| There are some in the PostgreSQL Cookbook
| (http://www.brasileiro.net/postgres) and Dan Wickstrom (from OpenACS.org)
| came up with one for OpenACS:
|
| http://openacs.org/new-file-storage/one-file?file_id=123

Good luck
Arnaud