Re: Can LIKE use indexes or not?

From: "John Sidney-Woollett" <johnsw(at)wardbrook(dot)com>
To: johnsw(at)wardbrook(dot)com
Cc: "David Garamond" <lists(at)zara(dot)6(dot)isreserved(dot)com>, "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Can LIKE use indexes or not?
Date: 2004-02-05 09:20:18
Message-ID: 4454.192.168.0.64.1075972818.squirrel@mercury.wardbrook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Poslusny 2004-02-05 09:22:29 Re: Can LIKE use indexes or not?
Previous Message John Sidney-Woollett 2004-02-05 08:58:50 Re: Can LIKE use indexes or not?