Case insensitive "contains" search

["Wim Ceulemans" <wim(dot)ceulemans(at)pophost(dot)eunet(dot)be>]

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 Software Solutions
Eglegemweg 3, 2811 Hombeek - Belgium
Tel +32(0)15 41 29 53 - Fax +32(0)15 41 29 54