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

Re: BUG #3394: Partial search not working

From: "Murali Doss" <Murali(dot)Doss(at)mphasis(dot)com>
To: "Michael Fuhr" <mike(at)fuhr(dot)org>
Cc: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>,<pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #3394: Partial search not working
Date: 2007-06-19 11:07:32
Message-ID: 7C83A8A6B56D3A478333B1DF47E18586B93005@mpbabgex01.corp.mphasis.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi Michael,

Same database dump is there Solaris, Windows and Linux and the partial
search query is displaying the expected results in Solaris and Windows
OS but the query returning 0 row in Linux OS.

SELECT * FROM tablename WHERE colname BETWEEN 'B' AND 'B~';


Any query to find the local settings and encoding.

Regards
Murali Doss T.S.


-----Original Message-----
From: Michael Fuhr [mailto:mike(at)fuhr(dot)org] 
Sent: Tuesday, June 19, 2007 3:51 PM
To: Murali Doss
Cc: Heikki Linnakangas; pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #3394: Partial search not working

On Tue, Jun 19, 2007 at 02:55:07PM +0530, Murali Doss wrote:
> No result but the matching data is available in table

What values are not matching that you expect to match?  Can you
provide a reproducible test case?  What are your locale settings
and encoding?

-- 
Michael Fuhr

In response to

Responses

pgsql-bugs by date

Next:From: pierceDate: 2007-06-19 11:10:37
Subject: ERROR: permission denied for schema pg_catalog
Previous:From: Michael FuhrDate: 2007-06-19 10:20:32
Subject: Re: BUG #3394: Partial search not working

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