Re: BUG #3394: Partial search not working - Mailing list pgsql-bugs

Murali Doss wrote:
> Partial search query is not working Linux OS with postgresql 8.2.4 but the
> same is working fine in windows and solaris OS.
>
> I like to know whether i need to run some patch in linux OS to make the
> partial search to work.
>
> SELECT * FROM tablename WHERE colname BETWEEN 'B-' AND 'B~' ORDER BY
> colname

What do you mean by "not working"? Does it give an error message?
Unexpected results?

Are you perhaps using a different locale on different platforms?

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com