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?
Ah. Good point. I ASSuMEd that what any C language program would use. IIRC, PostgreSQL uses Bison and Flex to generate the parsing grammars, and I don't know what those products output.
--
john r pierce, recycling bits in santa cruz
--
The unfacts, did we have them, are too imprecisely few to warrant our certitude.
