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.
Murali Doss T.S.
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
In response to
pgsql-bugs by date
|Next:||From: pierce||Date: 2007-06-19 11:10:37|
|Subject: ERROR: permission denied for schema pg_catalog|
|Previous:||From: Michael Fuhr||Date: 2007-06-19 10:20:32|
|Subject: Re: BUG #3394: Partial search not working|