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)
Список
Дерево обсуждения
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
Дата: