From: | Sferacarta Software <sferac(at)bo(dot)nettuno(dot)it> |
---|---|
To: | "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com>, "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>, Dan Gowin <DGowin(at)avantec(dot)net>, "PGSQL HACKERS (E-mail)" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re[2]: [HACKERS] JOIN syntax. Examples? |
Date: | 1999-01-11 14:45:51 |
Message-ID: | 0656.990111@bo.nettuno.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello Thomas,
venerdì, 11 dicembre 98, you wrote:
>> Microsoft SQL Server v6.5 have SQL92 join syntax. I don't have the
>> standard in front of me but here's what I remember.
TGL> OK, it's pretty clear that Oracle doesn't implement SQL92-syntax on
TGL> outer joins (unless they support it as an alternative; does anyone find
TGL> "OUTER JOIN" in the syntax docs?).
TGL> Let's assume that M$ may be close to standard, but given that they don't
TGL> bother following standards in other areas (WHERE x = NULL, etc) we can't
TGL> use them as a truth generator.
TGL> We are looking for a system which supports syntax like DeJuan gave:
TGL> SELECT * FROM (A LEFT OUTER JOIN B USING (X));
TGL> or
TGL> SELECT * FROM (A LEFT OUTER JOIN B ON (A.X = B.X));
TGL> etc. if we are going to try for the SQL92 standard,
TGL> rather than the Oracle form:
TGL> SELECT * FROM A, B WHERE A.X = (+) B.X;
TGL> or the Informix form:
TGL> SELECT * FROM A, OUTER B WHERE A.X = B.X;
TGL> (is the WHERE clause required here?)
TGL> Does anyone have a non-M$ RDBMS which implements SQL92 joins?
Download OCELOT for Win32 at http://ourworld.compuserve.com/homepages/OCELOTSQL
their database implements SQL92 joins.
Their home page says:
Ocelot makes the only Database Management System (DBMS) that supports
the full ANSI / ISO SQL Standard (1992).
...
This is also the only place on the Net where you can find documentation
that explains and provides examples of the full SQL-92 standard. This is version 1.0.
I'm trying it, is very interesting but it is only for M$-win.
-Jose'-
From | Date | Subject | |
---|---|---|---|
Next Message | Brook Milligan | 1999-01-11 19:18:10 | PQfinish in transactions |
Previous Message | Vadim Mikheev | 1999-01-11 14:03:31 | Re: [HACKERS] FOREIGN KEYs (Was: Benchmarking PGSQL against Microsoft SQL 7) |