Re: Allow disabling folding of unquoted identifiers to lowercase

John R Pierce <pierce@xxxxxxxxxxxx> · Fri, 29 Apr 2016 12:44:28 -0700



    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