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

Re: BUG #3394: Partial search not working

From: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
To: Murali Doss <Murali(dot)Doss(at)mphasis(dot)com>
Cc: Michael Fuhr <mike(at)fuhr(dot)org>, 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 12:01:18
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Murali Doss wrote:
> 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.


SELECT name, setting FROM pg_settings WHERE name LIKE 'lc_%';

The psql -l command shows you database encoding. Client and server 
encoding is possible get by the following commands:

SHOW client_encoding and SHOW server_encoding


In response to


pgsql-bugs by date

Next:From: Murali DossDate: 2007-06-19 12:51:19
Subject: Re: BUG #3394: Partial search not working
Previous:From: pierceDate: 2007-06-19 11:10:37
Subject: ERROR: permission denied for schema pg_catalog

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