Re: ILIKE
| От | Josh Berkus |
|---|---|
| Тема | Re: ILIKE |
| Дата | |
| Msg-id | 200302231302.27130.josh@agliodbs.com обсуждение |
| Ответ на | ILIKE (Peter Eisentraut <peter_e@gmx.net>) |
| Ответы |
Re: ILIKE
Re: ILIKE |
| Список | pgsql-hackers |
Peter,
Several reasons (because I like lists):
- Some other databases support ILIKE and it makes porting easier.
- For tables and/or subqueries that are too small to need an index, ILIKE is
perfectly acceptable.
- It's also useful for comparing expressions, and is faster to type than'jehosaphat' ~* '^Jehosaphat$', and certainly
muchfaster thanlower('jehosaphat') = lower('Jehosaphat')
Why this sudden urge to prune away perfectly useful operators?
--
Josh Berkus
Aglio Database Solutions
San Francisco
В списке pgsql-hackers по дате отправления: