Re: Allow disabling folding of unquoted identifiers to lowercase

John R Pierce <pierce@xxxxxxxxxxxx> · Fri, 29 Apr 2016 13:38:22 -0700



    On 4/29/2016 12:56 PM, John McKown
      wrote:

    
          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.
      
    
    are those the APIs the parser uses?

    
    -- 
john r pierce, recycling bits in santa cruz