"Nicolas Verger" <nicolas(at)verger(dot)net> writes:
> But I have a big problem : PostgreSQL doesn't allow Oracle style outer join,
> and Oracle doesn't allow Postgres style ...
Are you sure about that? Postgres supports ISO standard (ISO/IEC 9075,
SQL 1992) outer joins. Oracle claims to be compliant with that
standard. If they don't accept the standard syntax for outer joins,
then their claim of compliance is faulty. But last I heard, they did.
regards, tom lane