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

Murali Doss wrote:
> The following bug has been logged online:
>
> Bug reference:      3394
> Logged by:          Murali Doss
> Email address:      murali.doss@mphasis.com
> PostgreSQL version: 8.2.4
> Operating system:   Linux
> Description:        Partial search not working
> Details:
>
> Dear All,
>
> 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 don't think that it depends on OS. What is difference between working
and not working search?

> 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

Can you run EXPLAIN on your query and look if it is same on all OS?


    Zdenek