Postgres friendly RegEx? - Mailing list pgsql-general

From Jon Asher
Subject Postgres friendly RegEx?
Date
Msg-id d24c7af0612121322m6257a718x8f91640e497354d3@mail.gmail.com
Whole thread Raw
Responses Re: Postgres friendly RegEx?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Anyone care to correct this regex for PostgreSQL?  It works in C++ but Postgres have no love for it:
 
-{0,1}\d*\.{0,1}\d+\^{0,1}\d*\.{0,1}\d+
 
This regex accepts  (any num)^(pos num)  such as:
45.2^3
-45.2^3
10^2.5
 
 

pgsql-general by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: a question on SQL
Next
From: Tom Lane
Date:
Subject: Re: search_path when restoring to new db