Case in-sensitive

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

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

Chris

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