Hi!
Not long after I resolved my last problem with indices ('vaccum
analyze'), I stumbled upon another.
Check this:
filedb=# select file from filenew where file like '/home/zcalusic/rcs%';
returns
file
----------------------------------------------
/home/zcalusic/rcs
/home/zcalusic/rcs/linux
/home/zcalusic/rcs/linux/0_REPORTING-,v
/home/zcalusic/rcs/linux/10_bug-list.t,v
/home/zcalusic/rcs/linux/11_00-INDEX,v
...
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???
How can that be, when output above shows I DO have rows that satisfy
this query?
--
Zlatko