On Nov 16, 2014, at 3:52 PM, Seamus Abshere 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 regexp_matches('2033 21st
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', '\m