Re: BUG #4047: case preserve for columns

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 ?
>
>
>
>

In response to

Responses

Browse pgsql-bugs by date

  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