Re: Allow disabling folding of unquoted identifiers to lowercase

Поиск
Список
Период
Сортировка
От Klaus P. Pieper
Тема Re: Allow disabling folding of unquoted identifiers to lowercase
Дата
Msg-id 00b501d1a90d$bd6755b0$38360110$@gmail.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  (Raymond O'Donnell <rod@iol.ie>)
Список pgsql-general
> -----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"
Дата:
Сообщение: Re: Allow disabling folding of unquoted identifiers to lowercase
Следующее
От: Raymond O'Donnell
Дата:
Сообщение: Re: Allow disabling folding of unquoted identifiers to lowercase