Postgres friendly RegEx?

From: "Jon Asher" <jon(dot)asher(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres friendly RegEx?
Date: 2006-12-12 21:22:57
Message-ID: d24c7af0612121322m6257a718x8f91640e497354d3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-12-12 21:39:36 Re: search_path when restoring to new db
Previous Message Greg Sabino Mullane 2006-12-12 21:21:00 Re: a question on SQL