On Fri, Apr 29, 2016 at 2:44 PM, John R Pierce <pie...@hogranch.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
