Hi Mike, I have no idea about performance implications, but you may use the regex modifier "(?i)" for ignore case: name ~ '(?)airport'
Gerd ________________________________________ Von: mkgmap-dev <[email protected]> im Auftrag von Mike Baggaley <[email protected]> Gesendet: Montag, 24. Juli 2017 12:55:26 An: [email protected] Betreff: [mkgmap-dev] upper and lower case Hi, I wonder are there functions to convert values to upper or lower cases? I can't find anything in the style manual. I'm doing a lot of comparison of name fields such as name~'[Aa]irport' and think it would be much more efficient to first copy the name to an upper or lower case version and then do equality matches instead of the regular expression matches (this would also detect any oddly capitalized names such as AIrport). Any suggestions? Thanks, Mike _______________________________________________ mkgmap-dev mailing list [email protected] http://www.mkgmap.org.uk/mailman/listinfo/mkgmap-dev _______________________________________________ mkgmap-dev mailing list [email protected] http://www.mkgmap.org.uk/mailman/listinfo/mkgmap-dev
