Re: Can LIKE use indexes or not? - Mailing list pgsql-general

John Sidney-Woollett said:
> select * from t where new_upper_f like upper('MMM%');

I think I meant

select * from t where new_upper_f like 'MMM%';

or

select * from t where new_upper_f like upper('mmm%');

John