> -----Original Message----- > > > > 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. > > > > > > > > Any ideas? (PG13) > > > > > > > > Z > > > >
My apologies for wasting your time ☹ The issue was in an unrelated field!! Thank you Z
