| From: | Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at> |
|---|---|
| To: | "'Tom Ivar Helbekkmo'" <tih(at)kpnQwest(dot)no> |
| Cc: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | AW: AW: AW: Re: [SQL] behavior of ' = NULL' vs. MySQL v s. S tand ards |
| Date: | 2001-06-07 13:21:22 |
| Message-ID: | 11C1E6749A55D411A9670001FA687963368314@sdexcsrv1.f000.d0188.sd.spardat.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> > Thus it could be, that NULL in "where column = NULL" is not defined
> > to have a special meaning according to SQL92.
>
> The way I interpret Celko's interpretation of SQL92, that specific
> construct has a meaning; it evaluates to UNKNOWN, thus not to TRUE,
Imho the text refers to a content of a particular column of one particular row.
where table1.col1 = table2.col1
the content of table2.col1 is null --> comparison evaluates to UNKNOWN.
It does not state whether NULL is a valid constant expression.
Andreas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Lockhart | 2001-06-07 13:41:32 | Re: behavior of ' = NULL' vs. MySQL vs. Standards |
| Previous Message | Sergio Bruder | 2001-06-07 12:57:50 | Re: AW: AW: Re: [SQL] behavior of ' = NULL' vs. MySQL vs. S tand ards |