| From: | Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | 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 15:32:20 |
| Message-ID: | CALSLE1N-WnxujTjD+ED9u4pjFrUnHbm8zr9+SmMvu5NPAMGw1g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Wed, Jul 3, 2013 at 8:54 PM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> Agreed. The original poster specifically wanted "MYTABLE" and mytable
> to be the same, not "mytable" and mytable. Postgres is certainly
> non-standard in this area. I think the ability visiually distinguish
> lower-case letters better than upper-case letters has led to our
> behavior.
Not really, actually am looking for column aliases here and not the table.
Here is the example again when the aliases are unquoted:
- SELECT my_column as MY_COLUMN FROM my_table
The above SELECT will fold the alias name as my_column and not MY_COLUMN.
Regards...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2013-07-03 15:35:24 | Re: Unquoted column names fold to lower case |
| Previous Message | Bruce Momjian | 2013-07-03 15:24:02 | Re: Unquoted column names fold to lower case |