On Tue, Jul 23, 2002 at 02:35:40PM +0000, Carmen Wai wrote:
> Hello:
>
> 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)
No. But you can use ILIKE, which is a case-insensitive LIKE.
A
--
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M6K 3E3
+1 416 646 3304 x110