Re: case insensitive search

Gurudutt schrieb:
> Hello arun,
>
> ak>         how to do a case insensitive search on postgresql database. i will
> ak> enter a keyword in text field and it has to search for that keyword in
> ak> keywords field of table and should be case insensitive.
>
> why don't you use "ilike" to search for the pattern in the database.

or POSIX:

4.6.2. POSIX Regular Expressions

Table 4-10. Regular Expression Match Operators

Operator Description            Example
~     regex, case sensitive        'thomas' ~ '.*thomas.*'
~*     regex, case insensitive    'thomas' ~* '.*Thomas.*'
!~     not regex, case sensitive    'thomas' !~ '.*Thomas.*'
!~*     not regex, case insensitive    'thomas' !~* '.*vadim.*'

G,
K