On Thu, Jul 4, 2013 at 1:36 AM, Bruce Momjian <bruce@momjian.us> wrote:
And let's not forget that column aliases can be used as indentifiers in queries:
test=> SELECT 1 AS x test-> ORDER BY x; x --- 1 (1 row)
test=> SELECT 1 AS "X" ORDER BY x; ERROR: column "x" does not exist LINE 2: ORDER BY x;
Changing this would mean that the same identifier would have different case-folding rules depending on where it appeared in the query.
Sorry but I am not sure about your point here. Currently if the alias is quoted then same needs to be used in queries as identifies: SELECT 1 AS "X" ORDER BY "X";