Tom Lane wrote:
Greg Stark <[EMAIL PROTECTED]> writes:
The SQL spec has some detailed discussion of some strange null behaviours.
BTW, Teodor Sigaev pointed out today that we are also doing array
comparisons (array_eq, array_cmp) wrong.
Seems to me like at least array_eq is correct (from SQ
Greg Stark <[EMAIL PROTECTED]> writes:
> The SQL spec has some detailed discussion of some strange null behaviours.
BTW, Teodor Sigaev pointed out today that we are also doing array
comparisons (array_eq, array_cmp) wrong. In the recent extension
to make arrays support NULL entries, I had made th
Greg Stark <[EMAIL PROTECTED]> writes:
> The SQL spec has some detailed discussion of some strange null behaviours.
Sorry, forgot the reference. This is section 8.7 "" of the
SQL/Foundation. Pages 397-398 in this draft.
--
greg
---(end of broadcast)---
The SQL spec has some detailed discussion of some strange null behaviours.
Specifically "row(1,null) is null" is false but "row(1,null) is not null" is
*also* supposed to be false. Postgres currently gets this wrong. "is [not]
null" is apparently supposed to mean "all the fields are (not) null".
