On Wed, Jul 3, 2013 at 04:16:41PM +0200, Thomas Kellerer wrote:
> Theodore Petrosky, 03.07.2013 15:41:
> > sorry, but you misunderstand. this is the correct behavior of SQL.
> >
> > It is part of the specification to do this.
> >
>
> Not quite. The SQL standard requires folding to uppercase.
Agreed. The original poster specifically wanted "MYTABLE" and mytable
to be the same, not "mytable" and mytable. Postgres is certainly
non-standard in this area. I think the ability visiually distinguish
lower-case letters better than upper-case letters has led to our
behavior.
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://enterprisedb.com
+ It's impossible for everything to be true. +