regex failing

[Zahir Lalani]

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