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
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%')