Re: Warts with SELECT DISTINCT - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Warts with SELECT DISTINCT
Date
Msg-id 11287.1146763110@sss.pgh.pa.us
Whole thread Raw
In response to Re: Warts with SELECT DISTINCT  (Greg Stark <gsstark@mit.edu>)
List 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 by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Typo in ginxlog.c
Next
From: Tom Lane
Date:
Subject: Re: patch review, please: Autovacuum/Vacuum times via stats.