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