From: | "Nicolas Verger" <nicolas(at)verger(dot)net> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | RE: Select parser at runtime .... |
Date: | 2001-08-20 16:40:32 |
Message-ID: | PJEHLLEIIGKDIHEDKNAMCEDDCBAA.nicolas@verger.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> 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.
I find this on an Oracle Technical Forum :
- SQL 92 is a standard with 3 levels: entrey level, intermediate level and a
third level I - can't remember (sorry...)
-
- As far as I know, Oracle is SQL 92 entry level compliant.
- INNER JOIN, OUTER JOIN, LEFT JOIN etc belong to SQL 92
- intermediate level sintax and, therefore, will not work on Oracle.
-
- Regards,
- Danilo Gimenez
- Oracle DBA
So I haven't any solution.... Can I hope about a future implementation of
Oracle outer join style ?
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Clift | 2001-08-20 16:46:23 | Re: Re: CREATEDB Where ?? |
Previous Message | Mikheev, Vadim | 2001-08-20 16:39:42 | RE: User locks code |