Peter Eisentraut <peter_e(at)gmx(dot)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