This looks like a problem already reported, and patched here:
http://archives.postgresql.org/pgsql-committers/2007-05/msg00088.php
but that fix hasn't made it into any released version yet.
Thank you.
I fixed it in my application by changing index to upper() instead of lower :
CREATE UNIQUE INDEX toode_toode_unique_pattern_idx1
ON firma1.toode
USING btree
(upper(toode::text) text_pattern_ops);
and using
SELECT * FROM firma1.toode WHERE upper(toode) LIKE 'Ä%'
Will this work OK ?
Andrus.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
