[EMAIL PROTECTED] wrote:
<[EMAIL PROTECTED]> wrote:
LIKE is case-insensitive by default. To have it use your index, you
need to either make the index case-insensitive:
CREATE INDEX test_name ON test (name COLLATE NOCASE);
Sorry, tried to create the index this way, but it
still isn't used by
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)
IT> LIKE is case-insensitive by default. To have it use your index, you need
IT> to either make the index case-insensitive:
Thanks! It's clear now.
IT> What's the point of using LIKE if you don't have any wildcards in the
IT> pattern?
Actually I do have wildcards, this was just a test, my
[EMAIL PROTECTED] wrote:
I'm trying to get index used with LIKE queries:
CREATE TABLE test (name STRING);
CREATE INDEX test_name ON test (name);
LIKE is case-insensitive by default. To have it use your index, you need
to either make the index case-insensitive:
CREATE INDEX test_name ON test
4 matches
Mail list logo