From: | <Eugen(dot)Konkov(at)aldec(dot)com> |
---|---|
To: | "John R Pierce" <pierce(at)hogranch(dot)com> |
Cc: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #4047: case preserve for columns |
Date: | 2008-03-21 15:32:54 |
Message-ID: | 002a01c88b68$dbe5a8a0$1200a8c0@kharkov.localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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?
http://archives.postgresql.org/pgsql-hackers/2006-10/msg01527.php
----- 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 ?
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Eugen.Konkov | 2008-03-21 15:54:59 | subscribe |
Previous Message | Eugen.Konkov | 2008-03-21 15:28:55 | Re: BUG #4047: case preserve for columns |