Anyone care to correct this regex for PostgreSQL? It works in C++ butPostgres 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^310^2.5