Re: Allow disabling folding of unquoted identifiers to lowercase

On Fri, Apr 29, 2016 at 2:44 PM, John R Pierce <pierce(at)hogranch(dot)com> wrote:

> 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.
>

​Why? PostgreSQL is written in C. So use strncasecmp() instead of strncmp()
or strcasecmp() instead of strcmp() to test for a token.

> --
> john r pierce, recycling bits in santa cruz
>
>

--
The unfacts, did we have them, are too imprecisely few to warrant our
certitude.

Maranatha! <><
John McKown