Re: Unquoted column names fold to lower case

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