Another problem with indices?

From: Zlatko Calusic <zlatko(at)iskon(dot)hr>
To: pgsql-general(at)postgresql(dot)org
Subject: Another problem with indices?
Date: 2000-09-11 09:49:35
Message-ID: 87wvgjp8b4.fsf@atlas.iskon.hr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martin A. Marques 2000-09-11 10:05:28 problems with GRANT on Solaris 8
Previous Message kent 2000-09-11 08:49:09 Question of postgresql