Re: Unquoted column names fold to lower case - Mailing list pgsql-sql

From Dev Kumkar
Subject Re: Unquoted column names fold to lower case
Date
Msg-id CALSLE1PGznyeRKzrtAhqnktkMtnQ7ByprmOv-pxuM9EMAD63ow@mail.gmail.com
Whole thread Raw
In response to Re: Unquoted column names fold to lower case  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-sql
On Thu, Jul 4, 2013 at 12:38 AM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
Aliases are treated just like any other identifier.  The downcasing
happens in the lexer (src/backend/parser/scan.l), which is totally
unaware of the context in which this is happening; so there's no way to
tweak the downcasing behavior for only aliases and not other
identifiers.

Oh OK, that makes sense and yes can see through complexity.
So I believe when aliases are quoted then the scan process might be different and hence quotes aliases TEXT CASE gets preserved.

Regards...

pgsql-sql by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Unquoted column names fold to lower case
Next
From: Tom Lane
Date:
Subject: Re: Unquoted column names fold to lower case