Re: SELECT DISTINCT on boxes

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: SELECT DISTINCT on boxes
Дата
Msg-id 200407151432.i6FEWaD24348@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: SELECT DISTINCT on boxes  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #1194: Wrong interpretation of Asia/Nicosia timezone
Следующее
От: davidn-postgres@rebel.net.au
Дата:
Сообщение: Re: Improper processing of random values in sub-queries