Re: ~* + LIMIT => infinite time?

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