Re: ORDER BY 1 COLLATE

Peter Eisentraut <peter_e@gmx.net> writes:
> 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.

The ORDER BY 1 business seems to me to be legacy anyway.  I'm not
inclined to put in even more hacks to make strange combinations work
there --- I think we're likely to find ourselves painted into a corner
someday as it is.
        regards, tom lane