On Thu, Jul 4, 2013 at 02:00:24AM +0530, Dev Kumkar wrote: > On Thu, Jul 4, 2013 at 1:36 AM, Bruce Momjian <br...@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";
You would need to double-quote 'x' in the ORDER BY, but not in the target list (because case would be preserved there) --- that is confusing. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
