Re: [HACKERS] Re: Informix and OUTER join syntax
Jose Soares <jose@sferacarta.com>
From: Jose Soares <jose@sferacarta.com>
To: Don Baccus <dhogaza@pacifier.com>
Cc: Thomas Lockhart <lockhart@alumni.caltech.edu>, "Ansley, Michael" <Michael.Ansley@intec.co.za>, "'Bruce Momjian '" <pgman@candle.pha.pa.us>, "'PostgreSQL-development '" <pgsql-hackers@postgresql.org>
Date: 2000-01-17T14:17:56Z
Lists: pgsql-hackers
Don Baccus wrote: > At 03:20 AM 1/15/00 +0000, Thomas Lockhart wrote: > >> I was under the impression that if you used NATURAL JOIN, then the join > >> would be made on the declared keys. > > > >Nope. On column names in common. > > (phew!) This is how I remembered it. Though it's in Boston and I'm > in Portland (OR, that is), due to my space-headedness, I can strongly > recommend that interested folks spend some of those $25,000 or so > dollars saved by not using Oracle on a copy of Date's SQL primer :) > > (I forget the exact title, but it's pretty good. I'll probably pick > up the standard, too, but Date's book is as much critique as explanation > and the SQL 92 standard seems in need of critical comments) > > - Don Baccus, Portland OR <dhogaza@pacifier.com> > Nature photos, on-line guides, Pacific Northwest > Rare Bird Alert Service and other goodies at > http://donb.photo.net. > > ************ IMHO "A Guide to THE SQL STANDARD" by Date/Darwen is an interesting documentation but I'm reading another very, very interesting book about SQL, here the title in english: "SQL: The Standard Handbook" (Based on the New SQL Standard ISO 9075:1992(E) by Stephen Cannan and Gerard Otten. This a clear explanation of SQL standard made by two persons that colaborated direct or indirect to establish such Standard. José