Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group