Re: BUG #4047: case preserve for columns - Mailing list pgsql-bugs

From
Subject Re: BUG #4047: case preserve for columns
Date
Msg-id 001f01c88b68$48aa5040$1200a8c0@kharkov.localhost
Whole thread Raw
In response to BUG #4047: case preserve for columns  ("Eugen Konkov" <Eugen.Konkov@aldec.com>)
List pgsql-bugs
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@hogranch.com>
To: "Eugen Konkov" <Eugen.Konkov@aldec.com>
Cc: <pgsql-bugs@postgresql.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 ?

pgsql-bugs by date:

Previous
From: John R Pierce
Date:
Subject: Re: BUG #4047: case preserve for columns
Next
From:
Date:
Subject: Re: BUG #4047: case preserve for columns