IT> LIKE is case-insensitive by default. To have it use your index, you need IT> to either make the index case-insensitive: IT> IT> CREATE INDEX test_name ON test (name COLLATE NOCASE);
Sorry, tried to create the index this way, but it still isn't used by the query. telega) ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------