[GENERAL] Comparing results of regexp_matches

hi, I want to check if two similar-looking addresses have the same numbered street, like 20th versus 21st. 2033 21st Ave S 2033 20th Ave S (they're different) I get an error: # select regexp_matches('2033 21st Ave S', '\m(\d+(?:st|th))\M') = regexp_matches('2033 20th Ave S',

Re: [GENERAL] Comparing results of regexp_matches

On Nov 16, 2014, at 3:52 PM, Seamus Abshere sea...@abshere.net wrote: hi, I want to check if two similar-looking addresses have the same numbered street, like 20th versus 21st. 2033 21st Ave S 2033 20th Ave S (they're different) I get an error: # select