Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id A008E9FA2C7
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Sat,  2 Dec 2006 12:03:20 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024)
	with ESMTP id 65797-06 for <pgsql-sql-postgresql.org@postgresql.org>;
	Sat,  2 Dec 2006 12:03:14 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from mxfep03.bredband.com (mxfep03.bredband.com [195.54.107.76])
	by postgresql.org (Postfix) with ESMTP id F10C79F9F7B
	for <pgsql-sql@postgresql.org>; Sat,  2 Dec 2006 12:03:13 -0400 (AST)
Received: from ironport2.bredband.com ([195.54.107.84] [195.54.107.84])
	by mxfep03.bredband.com with ESMTP id
	<20061202160310.WCMA8861.mxfep03.bredband.com@ironport2.bredband.com>
	for <pgsql-sql@postgresql.org>; Sat, 2 Dec 2006 17:03:10 +0100
Received: from ua-83-227-204-174.cust.bredbandsbolaget.se (HELO zigo.dhs.org)
	([83.227.204.174])
	by ironport2.bredband.com with ESMTP; 02 Dec 2006 17:03:08 +0100
Received: from [192.168.0.3] (cosmo.zigo.dhs.org [192.168.0.3])
	by zigo.dhs.org (Postfix) with ESMTP
	id 5B0578640; Sat,  2 Dec 2006 17:02:56 +0100 (CET)
Message-ID: <4571A3AF.6070608@zigo.dhs.org>
Date: Sat, 02 Dec 2006 17:02:55 +0100
From: Dennis Bjorklund <db@zigo.dhs.org>
User-Agent: Thunderbird 1.5.0.8 (X11/20061025)
MIME-Version: 1.0
To: ken@kensystem.com
Cc: Martijn van Oosterhout <kleptog@svana.org>,
	pgsql-sql@postgresql.org
Subject: Re: [HACKERS] Case Preservation disregarding case
References: <200610271623.37525.beauh@bluefrogmobile.com>
	<1162003132.687.8.camel@pampa>
	<200610301928.51255.beauh@bluefrogmobile.com>
	<23177.1162265010@sss.pgh.pa.us>
	<EB48EBF3B239E948AC1E3F3780CF8F88012F88DD@MI8NYCMAIL02.Mi8.com>
	<45712E31.1030004@kensystem.com> <20061202133556.GC26365@svana.org>
	<457199E4.3010401@kensystem.com>
In-Reply-To: <457199E4.3010401@kensystem.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200612/26
X-Sequence-Number: 26982

Ken Johanson skrev:

> Has your experience with PG been different? If so I presume you have 
> have found a config that allows?:
> 
> SELECT
> pers.firstName,
> pers.lastname,

As long as you don't create the columns using quotes you can use that 
kind of names. For example

   CREATE TABLE foo (BAR int);

   INSERT INTO foo VALUES (42);

   SELECT BaR, bar, BAR, "bar" FROM foo;

But using "Bar" wont work.

/Dennis