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

From John R Pierce
Subject Re: BUG #4047: case preserve for columns
Date
Msg-id 47E3CFB2.5040207@hogranch.com
Whole thread Raw
In response to BUG #4047: case preserve for columns  ("Eugen Konkov" <Eugen.Konkov@aldec.com>)
List pgsql-bugs
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: "Eugen Konkov"
Date:
Subject: BUG #4047: case preserve for columns
Next
From:
Date:
Subject: Re: BUG #4047: case preserve for columns