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)
Thanks a lot! Carmen _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org