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