Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres friendly RegEx? - Mailing list pgsql-general

From Tom Lane
Subject Re: Postgres friendly RegEx?
Date
Msg-id 25220.1165959841@sss.pgh.pa.us
Whole thread Raw
In response to Postgres friendly RegEx?  ("Jon Asher" <jon.asher@gmail.com>)
Responses Re: Postgres friendly RegEx?  ("Jon Asher" <jon.asher@gmail.com>)
List pgsql-general
Tree view 
"Jon Asher" <jon.asher@gmail.com> writes:
> 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+

It works fine in Postgres, AFAICT.  Maybe you forgot to double the
backslashes in a string literal?  Otherwise, be more specific about
your problem.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: a question on SQL
Next
From: "Jon Asher"
Date:
Subject: Re: Postgres friendly RegEx?