Re: BUG #4047: case preserve for columns

It is have no any matter to me if it is upshifted or lowershifted on server
sidethe standard does not specify that output of queries MUST be
lowershifted/upshifted.why you do this?----- Original Message -----
From: "John R Pierce" <pierce(at)hogranch(dot)com>
To: "Eugen Konkov" <Eugen(dot)Konkov(at)aldec(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Sent: Friday, March 21, 2008 5:09 PM
Subject: Re: [BUGS] BUG #4047: case preserve for columns

> Eugen Konkov wrote:
>> Is there any workaround other then quoting to get working 1) and 2) as
>> expected?
>>
>
> The SQL standard actually says everything not quoted should be upshifted
> to upper case. PostgreSQL opted for lower case a long time ago and has
> stuck with this for legacy.
>
> If your "100K lines of SQL" are autogenerated, why not have the
> autogenerator quote everything thats supposed to be case specific,
> alleviating any such problems ?