Re: [HACKERS] Case sensitivity in identifiers

John Robinson writes ("Re: [HACKERS] Case sensitivity in identifiers"):
> Bruce Momjian writes ("Re: [HACKERS] Case sensitivity in identifiers"):
> > Right now, we lowercase arguments when the come in from the parser.  We
> > could preserve case for Create-type statements, and force lowercase on
> > all comparisons, but that is a big job, and I think we questioned the
> > value of it.

I should probably restate: the principal value of it would be (i) to
ensure that third party users of PostgreSQL are less likely to notice
the change to ANSI compliance as a problem within their tools
(i.e. only if they relied on same-name alternate-case identifiers,
rather than just not doing force-to-lower themselves), and (ii)
elegance (I think MS Access does it by force-to-lower and ODBC does it
by force-to-upper).

John.                                                         _     _
- --                                                        _  | |___| |_  _ _
John Robinson      46 Bank Street, Dumfries DG1 2PA, UK  | |_| / . \ ' \| ' \
+44 1387 247249     http://www.intelligent.co.uk/~john/   \___/\___/_||_|_||_|
All those signs I've been missing right there in your eyes        --Del Amitri

------------------------------