Skip site navigation (1) Skip section navigation (2)

Re: rationale behind quotes for camel case?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: rationale behind quotes for camel case?
Date: 2011-06-28 11:00:42
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
On 06/28/11 2:12 AM, fluca1978(at)infinito(dot)it wrote:
> Hi all,
> first of all I'm not expressing any critique against the use of quotes 
> for identifier expressed using camel case. However a lot of new 
> postgresql users seems to be unhappy with the use of quotes for camel 
> case identifiers, so I'd like to know what is the rationale behind it. 
> I mean, is a feature of the partser or is a need for it to work? 
> Anyone can point me to an explaination?

the SQL spec states that all identifiers are case independent unless 
quoted.   In fact, the spec says to upshift everything to all capitals 
(probably reflecting its 1980s IBM origins), but PG decided a long time 
ago to default to lower case, since the final result has the same effect.

john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

In response to


pgsql-general by date

Next:From: Merlin MoncureDate: 2011-06-28 13:43:58
Subject: Re: rationale behind quotes for camel case?
Previous:From: Emrul IslamDate: 2011-06-28 10:09:53
Subject: Multi-tenancy in Postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group