Chris,
> > Can I config the Postgresql so that it can match case
> > in-sensitive pattern
> > automatically? i.e. I don't need to explicit convert the pattern to lower
> > case like this: .....WHERE lower(textfield) LIKE lower(pattern)
>
> All you need to do is this:
>
> ......WHERE textfield ILIKE pattern
Though, keep in mind, lower(textfield) can be indexed, but ILIKE textfield
cannot.
--
-Josh Berkus
Aglio Database Solutions
San Francisco