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" <[EMAIL PROTECTED]>
To: "Eugen Konkov" <[EMAIL PROTECTED]>
Cc: <pgsql-bugs@postgresql.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 ?
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
