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:[EMAIL PROTECTED] Sent: Tuesday, June 19, 2007 3:51 PM To: Murali Doss Cc: Heikki Linnakangas; pgsql-bugs@postgresql.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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
