regex failing - Mailing list pgsql-general

From Zahir Lalani
Subject regex failing
Date
Msg-id DB9P251MB0546762BBFBA3476E8DE2635A727A@DB9P251MB0546.EURP251.PROD.OUTLOOK.COM
Whole thread Raw
In response to Re: bug or lacking doc hint  (Kirk Wolak <wolakk@gmail.com>)
Responses Re: regex failing
Re: regex failing
Re: regex failing
List pgsql-general

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

 

pgsql-general by date:

Previous
From: Jeremy Schneider
Date:
Subject: Re: typical active table count?
Next
From: Ron
Date:
Subject: Re: typical active table count?