ORDER BY 1 COLLATE

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: ORDER BY 1 COLLATE
Date: 2011-04-18 20:08:52
Message-ID: 1303157332.14718.11.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-04-18 20:20:49 Re: ORDER BY 1 COLLATE
Previous Message Peter Eisentraut 2011-04-18 19:52:47 Re: Open issues for collations