| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | "Frank Bax" <fbax(at)sympatico(dot)ca>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: simple? join |
| Date: | 2002-01-08 03:25:19 |
| Message-ID: | 21174.1010460319@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
"Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> writes:
>> So, when and if we get around to implementing this particular SQL99
>> feature, what you are suggesting will work. Right now it doesn't
>> (and I'll wager that darn few other SQL implementations support this
>> feature as yet, either).
> I think MySQL does.
Do they bother to check validity of the column reference at all?
The cheesy way to do this would be not to check; if you referenced a
non-functionally-dependent column, you'd get a randomly chosen element
value with no warning... but for correct queries it would look like
they had support.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Unnikrishnan Menon | 2002-01-08 04:24:49 | Porting Oracle Packages |
| Previous Message | Christopher Kings-Lynne | 2002-01-08 01:54:29 | Re: simple? join |