Re: Creating a VIEW with a POINT column - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Creating a VIEW with a POINT column
Date
Msg-id 3158.1214446781@sss.pgh.pa.us
Whole thread Raw
In response to Re: Creating a VIEW with a POINT column  (Jan Urbański <j.urbanski@students.mimuw.edu.pl>)
Responses Re: Creating a VIEW with a POINT column  (Jan Urbański <j.urbanski@students.mimuw.edu.pl>)
List pgsql-hackers
Jan Urbański <j.urbanski@students.mimuw.edu.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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: CVS Head psql bug?
Next
From: Jan Urbański
Date:
Subject: Re: Creating a VIEW with a POINT column