Re: Warts with SELECT DISTINCT

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Warts with SELECT DISTINCT
Дата
Msg-id 11287.1146763110@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Warts with SELECT DISTINCT  (Greg Stark <gsstark@mit.edu>)
Список pgsql-hackers
Greg Stark <gsstark@mit.edu> writes:
> Hm. This goes back to the earlier conversation about whether = should ever be
> true for two objects that aren't, well, equal. I thought there was some
> consensus at the time that sorting should impose a superficial ordering on
> items that compare equal but aren't in fact the same.

We forced that recently for text strings (overriding locale-specific
cases in strcoll()), but there certainly was not any intent to decree
that every datatype must do likewise.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Typo in ginxlog.c
Следующее
От: Tom Lane
Дата:
Сообщение: Re: patch review, please: Autovacuum/Vacuum times via stats.