Thread

1. BUG #1345: pgsql character comparison bug

   PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2004-12-10T21:41:10Z

   The following bug has been logged online:
   
   Bug reference:      1345
   Logged by:          Sir Ki-Sirk
   
   Email address:      akbarofmg@empal.com
   
   PostgreSQL version: 8.0 Beta
   
   Operating system:   WINDOW 2003 Enterprise
   
   Description:        pgsql character comparison bug
   
   Details: 
   
   
   I am a C++ and pgsql beginner.
   When using PostgreSQL 8.0.0 Beta 5 in Window-2003-Enterprise
   I find that PostgreSQL 8.0.0 Beta 5 has simple-character-comparison-bug
   
   see below;
   
   QUERY=
   
   select
   chr(8) <chr(9)  AS A1,
   chr(9) <chr(10) AS A2,
   chr(10)<chr(11) AS A3,
   chr(11)<chr(12) AS A4,
   chr(12)<chr(13) AS A5,
   chr(13)<chr(14) AS A6,
   chr(14)<chr(15) AS A7,
   chr(15)<chr(16) AS A8,
   chr(16)<chr(17) AS A9;
   
   Exec --->
   
    a1 | a2 | a3 | a4 | a5 | a6 | a7 | a8 | a9
   ----+----+----+----+----+----+----+----+---
    t  | t  | t  | t  | t  | f  | t  | t  | t
   (1 row)
   
   Oh! the value of a6 field is "f" !!!
   
   Please Fix this BUG
   
   
   

2. Re: BUG #1345: pgsql character comparison bug

   Tom Lane <tgl@sss.pgh.pa.us> — 2004-12-11T17:39:45Z

   "PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
   > select
   > chr(13)<chr(14) AS A6,
   
   > Oh! the value of a6 field is "f" !!!
   
   Works fine for me.  Check your locale setting.
   
   			regards, tom lane