Re: Creating a VIEW with a POINT column

=?UTF-8?B?SmFuIFVyYmHFhHNraQ==?= <j(dot)urbanski(at)students(dot)mimuw(dot)edu(dot)pl> writes:
>> Tom Lane wrote:
>>> Type point has no btree opclass, no hash opclass, and not even an
>>> operator named "=" (it looks like the functionality is named ~=
>>> for some odd reason). I'd be interested to hear either a proposal of
>>> a principled way to define DISTINCT, or a way to implement it that
>>> was better than comparing every element to every other element...

> The way I see it there's nothing wrong with the definition of DISTINCT
> and for types that can't be compared there is no way of calculating
> distinct values other than comparing every element to every other.

"for types that can't be compared"? Do you not see the logical
disconnect in that sentence?

regards, tom lane