On 06/28/11 2:12 AM, fluca1978@infinito.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