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
------------------------------
