What locale and encoding are you using?
Evidently the LIKE index optimization is failing, but I would
not have guessed that a string like 1:0: would cause a problem,
especially not if all the entries in the column contain just
digits and colons.
You can find plenty of material about LIKE+index p
Hi,
I use:
agro=# select version();
version
---
PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.95.3
compiled with "--enable-locales --enable-encoding --with-tcl" options on
Mandrake LINUX 7.2 with
