Re: SELECT DISTINCT on boxes

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bugs for PostgreSQL <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: SELECT DISTINCT on boxes
Date: 2004-07-15 14:32:36
Message-ID: 200407151432.i6FEWaD24348@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephan Szabo 2004-07-16 19:33:00 Re: Slow views
Previous Message Tom Lane 2004-07-15 14:29:46 Re: BUG #1194: Wrong interpretation of Asia/Nicosia timezone