Re: Can LIKE use indexes or not?
От | Uwe C. Schroeder |
---|---|
Тема | Re: Can LIKE use indexes or not? |
Дата | |
Msg-id | 200402061144.48464.uwe@oss4u.com обсуждение исходный текст |
Ответ на | Re: Can LIKE use indexes or not? ("John Sidney-Woollett" <johnsw@wardbrook.com>) |
Список | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Why don't you use select * from t where new_upper_f ilike 'mmm%'; The ilike operator ignores case and you would get rid of the function call. On Thursday 05 February 2004 01:20 am, John Sidney-Woollett wrote: > 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 > > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend - -- UC - -- Open Source Solutions 4U, LLC 2570 Fleetwood Drive Phone: +1 650 872 2425 San Bruno, CA 94066 Cell: +1 650 302 2405 United States Fax: +1 650 872 2417 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFAI+6wjqGXBvRToM4RAgY8AKCmTr8JQpbDd+FMEZCG1ITVIYH+CQCeJ45C IHZxeLxj60UL+TlhXfH6pdM= =JOOY -----END PGP SIGNATURE-----
В списке pgsql-general по дате отправления: