them to switch ON preserveCase option and escape from those head
acheing described above.
Developers, lets do forward step as you do it with UPPERCASE changing it to
lowercase
I hope you will understand us who moveing to PG and, I hope, you will change
your mind about casePreserve
Thanks
PS: Any wh
m some DB to PG
and let them to switch ON preserveCase option and escape from those head
acheing described above.
Developers, lets do forward step as you do it with UPPERCASE changing it to
lowercase
I hope you will understand us who moveing to PG and, I hope, you will change
your mind about cas
ot; <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "John R Pierce" <[EMAIL PROTECTED]>;
Sent: Friday, March 21, 2008 6:43 PM
Subject: Re: [BUGS] BUG #4047: case preserve for columns
<[EMAIL PROTECTED]> writes:
It is have no any matter to me if it is upshifte
<[EMAIL PROTECTED]> writes:
> 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.
Yes it does. I quote SQL92 section 5.2 syntax rule 10:
The of a is equivalent
ohn R Pierce" <[EMAIL PROTECTED]>
To: "Eugen Konkov" <[EMAIL PROTECTED]>
Cc:
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
ot; <[EMAIL PROTECTED]>
Cc:
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 sh
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
The following bug has been logged online:
Bug reference: 4047
Logged by: Eugen Konkov
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3
Operating system: Windows XP
Description:case preserve for columns
Details:
1)
SELECT Id FROM MYTABLE;
$sth= fetchall_hashr