Re: Unquoted column names fold to lower case

On Wed, Jul  3, 2013 at 09:02:20PM +0530, Dev Kumkar wrote:
> On Wed, Jul 3, 2013 at 8:54 PM, Bruce Momjian <bruce@momjian.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.

Yes, both the identifier names and alias names are folded to lower case.
I never thought of them as different, but you are right, they are, and
we are non-standard in both areas.  Sorry.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +