Re: Unquoted column names fold to lower case

Поиск
Список
Период
Сортировка
От Dev Kumkar
Тема Re: Unquoted column names fold to lower case
Дата
Msg-id CALSLE1PGznyeRKzrtAhqnktkMtnQ7ByprmOv-pxuM9EMAD63ow@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Unquoted column names fold to lower case  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Unquoted column names fold to lower case
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Unquoted column names fold to lower case