Re: [BUGS] BUG #4047: case preserve for columns

2008-03-25 Thread Eugen.Konkov
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

Re: [BUGS] BUG #4047: case preserve for columns

2008-03-24 Thread Eugen.Konkov
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

Re: [BUGS] BUG #4047: case preserve for columns

2008-03-21 Thread Eugen.Konkov
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

Re: [BUGS] BUG #4047: case preserve for columns

2008-03-21 Thread Tom Lane
<[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

Re: [BUGS] BUG #4047: case preserve for columns

2008-03-21 Thread Eugen.Konkov
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

Re: [BUGS] BUG #4047: case preserve for columns

2008-03-21 Thread Eugen.Konkov
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

Re: [BUGS] BUG #4047: case preserve for columns

2008-03-21 Thread John R Pierce
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

[BUGS] BUG #4047: case preserve for columns

2008-03-21 Thread Eugen Konkov
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