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

BUG #1129: select query returns multiple results for a japanese characters

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1129: select query returns multiple results for a japanese characters
Date: 2004-04-07 06:31:47
Message-ID: 20040407063147.DA174CF50CD@www.postgresql.com (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1129
Logged by:          prasvenk

Email address:      prasvenk(at)yahoo(dot)com

PostgreSQL version: 7.4

Operating system:   rehat linux 9

Description:        select query returns multiple results for a japanese 
characters 

Details: 

Hi,
I tried the following query on a windows 2000 machine with cywin and 
postgres 7.4 

select * from colour_master where colour_name=' ';

this returned one row which is correct.

i passed the same query to a same database but on a linux machine with 
postgres 7.4.2 it returned me around 5 rows which is not correct . 

these are the rows which were returned.
  
      
   
  
    

Any kind of help will the appreciable.

Thanks in advance.
Regards,
Prasvenk


Responses

pgsql-bugs by date

Next:From: Gabriel WeinbergDate: 2004-04-07 13:42:14
Subject: Re: Sequential Scan Index Bug
Previous:From: Bruno Wolff IIIDate: 2004-04-07 05:37:42
Subject: Re: Sequential Scan Index Bug

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