Re: BUG #4047: case preserve for columns

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
Subject: Re: BUG #4047: case preserve for columns
Date: 2008-03-21 15:09:38
Message-ID: 47E3CFB2.5040207@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ?

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Eugen.Konkov 2008-03-21 15:28:55 Re: BUG #4047: case preserve for columns
Previous Message Eugen Konkov 2008-03-21 14:44:52 BUG #4047: case preserve for columns