| From: | Don Baccus <dhogaza(at)pacifier(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
| Cc: | Magnus Hagander <mha(at)sollentuna(dot)net>, Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: comparing rows |
| Date: | 2000-08-03 14:32:36 |
| Message-ID: | 3.0.1.32.20000803073236.014db590@mail.pacifier.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
At 10:07 AM 8/3/00 -0400, Tom Lane wrote:
>Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> writes:
>> btw, it appears that SQL99 (haven't checked SQL92) specifies that
>
>> test=# select (1,2,3) = (1,2,null);
>> ?column?
>> ----------
>
>> (1 row)
>
>> should return FALSE, not NULL.
>
>What? If so, they broke it pretty badly.
Date disagrees with Thomas on this one, too.
On the other hand, select (2,2,3) = (1,2,null) would be false
because 1 <> 2, therefore the result is not unknown.
- 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 | Don Baccus | 2000-08-03 14:35:13 | Re: comparing rows |
| Previous Message | Bruce Momjian | 2000-08-03 14:24:28 | Re: comparing rows |