For those interested in porting from Oracle to PG, refer
http://www.compiere.org/technology/pg/index.html
Compiere is an Open Source accounting system designed around Oracle.
It uses Oracle features extensively. The desire to port this to
PG shows some of the present limitations in PG.
I seem to recall that someone has a patch for hierarchal Queries.
For your interest,
john