hi there!
the operators you want are ~ and ~* and !~ and !~*.
select name from table where name ~* 'test';
to see all operators availlable type \do in psql's interactive mode ;)
Regards,
Nuno Silva
Derek wrote:
anyone know how I force a case insensitive search through a postgres
database.
I've got a search looking for 'something like '%something%' but this won't
find 'SOMETHING'...if you know what I mean!?
Thanks in advance for any help
Derek
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
