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
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.
So in
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 null predicate of the
SQL/Foundation. Pages 397-398 in this draft.
--
greg
---(end of
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