Re: BUG #3394: Partial search not working

Murali Doss wrote:
> The following bug has been logged online:
>
> Bug reference: 3394
> Logged by: Murali Doss
> Email address: murali(dot)doss(at)mphasis(dot)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