Re: Allow disabling folding of unquoted identifiers to lowercase

Поиск
Список
Период
Сортировка
Искать
От
Klaus P. Pieper
Тема
Re: Allow disabling folding of unquoted identifiers to lowercase
Дата
в 09:41:13
Msg-id
00b501d1a90d$bd6755b0$38360110$@gmail.com
Ответ на
Список
Дерево обсуждения
Allow disabling folding of unquoted identifiers to lowercase Evgeny Morozov <evgeny.morozov+list+pgsql@shift-technology.com>
Re: Allow disabling folding of unquoted identifiers to lowercase "Peter J. Holzer" <hjp-pgsql@hjp.at>
Re: Allow disabling folding of unquoted identifiers to lowercase "Klaus P. Pieper" <kpi6288@gmail.com>
Re: Allow disabling folding of unquoted identifiers to lowercase Raymond O'Donnell <rod@iol.ie>
Re: Allow disabling folding of unquoted identifiers to lowercase John R Pierce <pierce@hogranch.com>
Re: Allow disabling folding of unquoted identifiers to lowercase John McKown <john.archie.mckown@gmail.com>
Re: Allow disabling folding of unquoted identifiers to lowercase John R Pierce <pierce@hogranch.com>
Re: Allow disabling folding of unquoted identifiers to lowercase John McKown <john.archie.mckown@gmail.com>
Re: Allow disabling folding of unquoted identifiers to lowercase Tom Lane <tgl@sss.pgh.pa.us>
Re: Allow disabling folding of unquoted identifiers to lowercase Evgeny Morozov <evgeny.morozov+list+pgsql@shift-technology.com>
Re: Allow disabling folding of unquoted identifiers to lowercase John McKown <john.archie.mckown@gmail.com>
Re: Allow disabling folding of unquoted identifiers to lowercase Evgeny Morozov <evgeny.morozov@shift-technology.com>
Re: Allow disabling folding of unquoted identifiers to lowercase Guillaume Lelarge <guillaume@lelarge.info>
Re: Allow disabling folding of unquoted identifiers to lowercase John McKown <john.archie.mckown@gmail.com>
> -----Ursprüngliche Nachricht-----
> 
> What exactly is the problem you are trying to solve?
> 
> If you and your users are consistent about never using quotes, your users
can
> write:
> 
> SELECT MyColumn FROM MyTable ORDER BY MyColumn;
> 
> It will select mycolumn from mytable, but that doesn't matter, since you
> created the table with
> 
>     CREATE MyTable (MyColumn varchar);
> 
> so you really have a table mytable with a column mycolumn, not a table
> MyTable with a column MyColumn.

I use 50% of my time Sybase and 50% PostgreSQL.  

For me is the way Sybase works is just more convenient: 

CREATE MyTable (MyColumn varchar); 

creates a camel cased table MyType and field MyColumn. 

SELECT * FROM SYSCATALOG gives MyTable. 

This is better readable when you use long table / fiel names. 

The user can then use whatever he wants: mytable, MyTable, myTABLE, ... 

Klaus



В списке pgsql-general по дате отправления
От: Peter J. Holzer
Дата:
От: Raymond O'Donnell
Дата:
FAQ