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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | pierce | 2007-06-19 11:10:37 | ERROR: permission denied for schema pg_catalog |
Previous Message | Michael Fuhr | 2007-06-19 10:20:32 | Re: BUG #3394: Partial search not working |