| From: | Don Baccus <dhogaza(at)pacifier(dot)com> |
|---|---|
| To: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>, "Ansley, Michael" <Michael(dot)Ansley(at)intec(dot)co(dot)za> |
| Cc: | "'Bruce Momjian '" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "'PostgreSQL-development '" <pgsql-hackers(at)postgreSQL(dot)org> |
| Subject: | Re: [HACKERS] Re: Informix and OUTER join syntax |
| Date: | 2000-01-15 04:52:51 |
| Message-ID: | 3.0.1.32.20000114205251.0109e880@mail.pacifier.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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(at)pacifier(dot)com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2000-01-15 05:31:31 | Re: [HACKERS] libpq+MB/putenv(), getenv() clean up |
| Previous Message | Don Baccus | 2000-01-15 04:49:12 | Re: [HACKERS] psql variables fixed (?) |