X-Original-To: pgsql-interfaces@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 1D503475AA9
	for <pgsql-interfaces@postgresql.org>;
	Mon, 31 Mar 2003 17:16:51 -0500 (EST)
Received: from fileserver.mwk.co.nz (unknown [210.55.107.146])
	by postgresql.org (Postfix) with ESMTP id 22E3547580B
	for <pgsql-interfaces@postgresql.org>;
	Mon, 31 Mar 2003 17:16:50 -0500 (EST)
Received: from localhost.localdomain (localhost.localdomain [127.0.0.1])
	by fileserver.mwk.co.nz (Postfix) with ESMTP id 242705F2B5
	for <pgsql-interfaces@postgresql.org>;
	Tue,  1 Apr 2003 10:16:46 +1200 (NZST)
Subject: Oracle Porting, Compiere
From: John Huttley <john@mwk.co.nz>
To: "pgsql-interfaces@postgresql.org" <pgsql-interfaces@postgresql.org>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-Mailer: Ximian Evolution 1.0.8 (1.0.8-11) 
Date: 01 Apr 2003 10:16:46 +1200
Message-Id: <1049149006.891.4.camel@fileserver.mwk.co.nz>
Mime-Version: 1.0
X-Spam-Status: No, hits=-9.0 required=5.0
	tests=BAYES_20,TO_ADDRESS_EQ_REAL,USER_AGENT_XIMIAN
	autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200303/183
X-Sequence-Number: 3932

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