| From: | Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Thomas Kellerer <spam_eater(at)gmx(dot)net>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Unquoted column names fold to lower case |
| Date: | 2013-07-03 20:30:24 |
| Message-ID: | CALSLE1NcZj2gQAr9PxUC_2o_OJVQYbvLqr_0zhGPSLrjyXocTQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Thu, Jul 4, 2013 at 1:36 AM, Bruce Momjian <bruce(at)momjian(dot)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";
Regards...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dev Kumkar | 2013-07-03 21:01:20 | Re: Unquoted column names fold to lower case |
| Previous Message | Bruce Momjian | 2013-07-03 20:06:52 | Re: Unquoted column names fold to lower case |