Re: [PERFORM] col1 ILIKE 'foo%' not behaving the same as lower(col1) LIKE 'foo%'

al index on lower(col1)) And just pretend that there isn’t an ILIKE. On 2/12/09 4:04 AM, "Richard Huxton" wrote: milos d wrote: > Hello, > > I have a table 'foo_bar' with a column 'col1' defined as > 'col1 varchar(512)'. This column is

[PERFORM] col1 ILIKE 'foo%' not behaving the same as lower(col1) LIKE 'foo%'

Hello, I have a table 'foo_bar' with a column 'col1' defined as 'col1 varchar(512)'. This column is indexed using an expression index defined as CREATE INDEX ix_foo_bar_by_col1 ON foo_bar(lower(col1) col1 varchar_pattern_ops) The problem is when I try matching using ILIKE, (col1 ILIKE 'foo%')