On Tue, Jun 27, 2023 at 11:59 AM Zahir Lalani <ZahirLalani@oliver.agency> wrote:
> Hi All > > > > Got a weird one. I am using the regex below to case match numeric only > values. > > > > '^([0-9]+[.]?[0-9]*)$' > > > > This works well by and large but not for a value like “1234:567”. This > seems to match positive and then fails due to not being an actual number in > the subsequent cast. > > > Works (returns false) here: select '1234:567' ~ '^([0-9]+[.]?[0-9]*)$'; https://mail.google.com/mail/u/0/?tab=mm&zx=y3hfqt48pyg7#all/FMfcgzGsnLNNXcRVCVNpjQhGknMSVLKn David J.
