| 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: | Whole Thread | Raw Message | 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
| 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 |