Re: ILIKE

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 much faster than
	lower('jehosaphat') = lower('Jehosaphat')

Why this sudden urge to prune away perfectly useful operators?

-- 
Josh Berkus
Aglio Database Solutions
San Francisco