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 majordomo@postgresql.org so that your
message can get through to the mailing list cleanly