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