Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UuP5f-0001fh-Dx for pgsql-sql@arkaria.postgresql.org; Wed, 03 Jul 2013 15:35:31 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1UuP5e-0001pr-RJ for pgsql-sql@arkaria.postgresql.org; Wed, 03 Jul 2013 15:35:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UuP5d-0001pi-Rs for pgsql-sql@postgresql.org; Wed, 03 Jul 2013 15:35:29 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UuP5a-00053Y-Ch for pgsql-sql@postgresql.org; Wed, 03 Jul 2013 15:35:29 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1UuP5Y-00060F-L5; Wed, 03 Jul 2013 11:35:24 -0400 Date: Wed, 3 Jul 2013 11:35:24 -0400 From: Bruce Momjian To: Dev Kumkar Cc: Thomas Kellerer , pgsql-sql@postgresql.org Subject: Re: Unquoted column names fold to lower case Message-ID: <20130703153524.GB6492@momjian.us> References: <1372858894.60580.YahooMailClassic@web161605.mail.bf1.yahoo.com> <20130703152402.GA6492@momjian.us> 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 09:02:20PM +0530, Dev Kumkar wrote: > On Wed, Jul 3, 2013 at 8:54 PM, Bruce Momjian wrote: > > 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. > > > Not really, actually am looking for column aliases here and not the table. Here > is the example again when the aliases are unquoted: > - SELECT my_column as MY_COLUMN FROM my_table > > The above SELECT will fold the alias name as my_column and not MY_COLUMN. Yes, both the identifier names and alias names are folded to lower case. I never thought of them as different, but you are right, they are, and we are non-standard in both areas. Sorry. -- 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