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
|
Список | 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 по дате отправления: