Manvendra <manvendra2525(at)gmail(dot)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