Re: NULL handling in 1D array comparison - Mailing list pgsql-bugs

Manvendra <manvendra2525@gmail.com> writes:
> Comparison should return UNKNOWN but it's returning a true.

> postgres=# select array[null]=array[null];

Yeah, that's intentional, because we have to be able to sort arrays.
Comparison of composites behaves similarly, btw.

> SQL-99 standard use to say it should come out as UNKNOWN

We're going to politely ignore the spec on this.

            regards, tom lane