Peter Eisentraut <pete...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers