Hi
A 'contains' search in postgreSQL is:
select * from tablex where name = '%test%';
When I want exactly the same but case insensitive, how do I do that? By
searching through the mail archive I came up with:
select * from tablex where name ~* 'test';
But this is not quite the same because it also finds for example 'tempest',
whereas the like search does not find it. So is there a postgreSQL operator
that does the same as the like %% search but case insensitive?
Regards
Wim Ceulemans
Nice bvba