| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Unquoted column names fold to lower case |
| Date: | 2013-07-03 15:24:02 |
| Message-ID: | 20130703152402.GA6492@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dev Kumkar | 2013-07-03 15:32:20 | Re: Unquoted column names fold to lower case |
| Previous Message | Thomas Kellerer | 2013-07-03 14:16:41 | Re: Unquoted column names fold to lower case |