Tom Lane <tgl@sss.pgh.pa.us> writes:
> Zlatko Calusic <zlatko@iskon.hr> writes:
> > but if I add one '/' before wildcard '%' (as I initially would like to
> > do it):
>
> > filedb=# select file from filenew where file like '/home/zcalusic/rcs/%';
> > file
> > ------
> > (0 rows)
>
> > No rows???
>
> Which Postgres version are you running, and in what LOCALE setting
> on what platform?
>
Postgres version is 7.0.2. (running on Debian GNU/Linux)
I'm using hr_HR locale (Croatian locale), LATIN2 encoding.
> Is there an index on filenew(file)? If so, does dropping it change
> the results?
>
I have an index on the column in the question, and yes, droping the
index instantly recovers from the bad behavior i.e. queries return
good results.
--
Zlatko