Re: SELECT DISTINCT on boxes - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: SELECT DISTINCT on boxes
Date
Msg-id 200407151432.i6FEWaD24348@candle.pha.pa.us
Whole thread Raw
In response to Re: SELECT DISTINCT on boxes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> 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 this ...

Yes, we would have to document it in the release notes but it is quite
surprising at is currently is configured.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1194: Wrong interpretation of Asia/Nicosia timezone
Next
From: davidn-postgres@rebel.net.au
Date:
Subject: Re: Improper processing of random values in sub-queries