ORDER BY 1 COLLATE - Mailing list pgsql-hackers

From Peter Eisentraut
Subject ORDER BY 1 COLLATE
Date
Msg-id 1303157332.14718.11.camel@vanquo.pezone.net
Whole thread Raw
Responses Re: ORDER BY 1 COLLATE  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
This came from a review by Noah Misch a great while ago:

test=> SELECT b FROM foo ORDER BY 1 COLLATE "C";
ERROR:  42804: collations are not supported by type integer

According to SQL92, this should be supported.  Do we want to bother?  It
doesn't look hard to fix, so it's really only a question of whether this
would be useful, or its absence would be too confusing.



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Open issues for collations
Next
From: Tom Lane
Date:
Subject: Re: ORDER BY 1 COLLATE