Re: Unquoted column names fold to lower case

Поиск
Список
Период
Сортировка
От Dev Kumkar
Тема Re: Unquoted column names fold to lower case
Дата
Msg-id CALSLE1N-WnxujTjD+ED9u4pjFrUnHbm8zr9+SmMvu5NPAMGw1g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Unquoted column names fold to lower case  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-sql
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.

Regards...

В списке pgsql-sql по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Unquoted column names fold to lower case
Следующее
От: Dev Kumkar
Дата:
Сообщение: Re: Unquoted column names fold to lower case