Added to TODO:
* Fix data types where equality comparison isn't intuitive, e.g. box
---
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I found the cause. Equals for boxes compares only area, \do:
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I found the cause. Equals for boxes compares only area, \do:
>
> ... which is in itself pretty bogus IMHO. There are a couple of the
> geometric types for which '=' does not do what you'd really expect.
> I've been wondering if we c
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I found the cause. Equals for boxes compares only area, \do:
... which is in itself pretty bogus IMHO. There are a couple of the
geometric types for which '=' does not do what you'd really expect.
I've been wondering if we could get away with changing
Bruce Momjian wrote:
> Is there a way to do a SELECT DISTINCT on boxes:
>
> test=> create TABLE t3 (a box);
> CREATE TABLE
> test=> insert into t3 values ('(2,2),(1,1)');
> INSERT 17232 1
> test=> insert into t3 values ('(2,2),(1,1)');
> INSERT 17233
Is there a way to do a SELECT DISTINCT on boxes:
test=> create TABLE t3 (a box);
CREATE TABLE
test=> insert into t3 values ('(2,2),(1,1)');
INSERT 17232 1
test=> insert into t3 values ('(2,2),(1,1)');
INSERT 17233 1
test=> insert into t3 valu
