Re: [HACKERS] Select parser at runtime ....

2001-08-20 Thread Tom Lane
"Nicolas Verger" <[EMAIL PROTECTED]> 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 w

RE: [HACKERS] Select parser at runtime ....

2001-08-20 Thread Nicolas Verger
> De : Tom Lane > 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

RE: [HACKERS] Select parser at runtime ....

2001-08-20 Thread Nicolas Verger
> Tom Lane writes : > 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. Well, I can't find it into the documentation, and the postgres syntax does not work so I th

[HACKERS] Select parser at runtime ....

2001-08-20 Thread Nicolas Verger
Hello, I'm pretty new to PostgreSQL, (I'm a (young) oracle DBA) We need to work with Oracle (some heavy client of our society want Oracle for security or maintenance), but we want to work with PostgreSQL too, cause it's more performant, less administration, ... in few words : It's the future But