Hello We made Compiere (Open source ERP system) to Firebird (Fyracle) This is special version of Firebird with added Oracle compatibility (Oracle PL/SQL). It made porting much easier, but our experience show that it would be now also not very difficult with other databases like PostgreSQL.
Compiere contained lot of PL/SQL which size is now largely reduced. Main problem is some SQL constructions which are not supported. Particulary something like this is very important: UPDATE sometable set (col1,col2) = (select col_a,col_b from another_table where ....) This construction seems to be quite useful in another cases. Would be it diffcult and possible to add such syntax to PostgreSQL ? Marek Mosiewicz http://www.jotel.com.pl ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly