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?
Is there an index on filenew(file)? If so, does dropping it change
the results?
regards, tom lane