David Gagnon wrote:
>
>>
>>
>>
>>
> Maybe there is a simple way to to this but I want find string X in
> different column. The search must not be case sensitive.
>
> So that searching "aBc" in "abcDef" return true. I don't want
> META-CHaracter. Or at least I don't want meta-character to cause
> errors (i.e.: No
>
Ok, how about a better way to do this?
select * from mytable where lower(mycol) LIKE lower("%" || lower(X) || "%");
Does this work? It seems that this may be the best way to handle this
sort of thing.
Best Wishes,
Chris Travers
Metatron Technology Consulting
> ERROR: invalid regular expression: brackets [] not balanced.
>
>
>
> Thanks for your help
> /David
>
>
>
>
>
>
>
>
>>> I found this in the manual .. but haven't found example :-(:
>>> : ....with ***=, the rest of the RE is taken to be a literal string,
>>> with all characters considered ordinary characters.
>>>
>>
>>
>> Read again the entire sentence, especially the first few words:
>>
>> If an RE begins with ***=, the rest of the RE is taken to be a
>> literal string, with all characters considered ordinary characters.
>>
>> Here are some examples:
>>
>> SELECT 'test string' ~ 'test[*';
>> ERROR: invalid regular expression: brackets [] not balanced
>>
>> SELECT 'test string' ~ '***=test[*';
>> ?column? ----------
>> f
>> (1 row)
>>
>> SELECT 'test[* string' ~ '***=test[*';
>> ?column? ----------
>> t
>> (1 row)
>>
>>
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
>
