Typea,
> Oh, and the lower(field) LIKE is MySQL compatible, but I don't think
> MySQL
> has an ILIKE... We're abandoning the MySQL support now anyway, since
> we
> NEED performance way more than we need MySQL compatibility.
ILIKE is SQL-spec. There's reasons to use any:
ILIKE is slightly faster on un-anchored text searches ("name ILIKE
'%john%'")
lower(column) can be indexed for anchored text searches ("lower(name)
LIKE 'john%'")
"~*" cannot be indexed, but will accept regexp operators for
sophisticated text searches ("name ~* 'jo[han]n?'")
-Josh Berkus