Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UuOut-00017I-86 for pgsql-sql@arkaria.postgresql.org; Wed, 03 Jul 2013 15:24:23 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1UuOur-00076Y-Gt for pgsql-sql@arkaria.postgresql.org; Wed, 03 Jul 2013 15:24:21 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UuOuh-0006tR-O9 for pgsql-sql@postgresql.org; Wed, 03 Jul 2013 15:24:12 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UuOua-0004mE-B4 for pgsql-sql@postgresql.org; Wed, 03 Jul 2013 15:24:11 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1UuOuY-000165-Li; Wed, 03 Jul 2013 11:24:02 -0400 Date: Wed, 3 Jul 2013 11:24:02 -0400 From: Bruce Momjian To: Thomas Kellerer Cc: pgsql-sql@postgresql.org Subject: Re: Unquoted column names fold to lower case Message-ID: <20130703152402.GA6492@momjian.us> References: <1372858894.60580.YahooMailClassic@web161605.mail.bf1.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org 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 http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql