On 4/29/2016 10:21 AM, Evgeny Morozov wrote:
It would be great if Postgres had a server setting that allowed the
automatic folding of identifiers to lowercase to be disabled, so that
camel case identifiers could be used without having to quote every
single identifier, i.e.
SELECT MyColumn FROM MyTable ORDER BY MyColumn
instead of
SELECT "MyColumn" FROM "MyTable" ORDER BY "MyColumn"
I suspect this would be painful for the parser, unless you also enforced
that all SQL keywords were in a specific case (all lower would be the
minimal impact to the code). otherwise the parser would have to
lower() every token to check to see if its a keyword, but if not, revert
it to its original case.
--
john r pierce, recycling bits in santa cruz