RE: Select parser at runtime ....

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 ?

In response to

Browse pgsql-hackers by date

  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