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
begin:vcard fn:Chris Travers n:Travers;Chris email;internet:chris@xxxxxxxxxxxxxxxx x-mozilla-html:FALSE version:2.1 end:vcard
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
