| From: | Zahir Lalani <ZahirLalani(at)oliver(dot)agency> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | RE: regex failing |
| Date: | 2023-06-28 06:56:03 |
| Message-ID: | DB9P251MB0546B428CE73A5D7ED8D1BEFA724A@DB9P251MB0546.EURP251.PROD.OUTLOOK.COM |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> -----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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dominique Devienne | 2023-06-28 07:46:53 | LibPQ: PQresultMemorySize as proxy to transfered bytes |
| Previous Message | Adrian Klaver | 2023-06-27 23:46:04 | Re: connect postgres using url |