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