Re: Postgres friendly RegEx?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jon Asher" <jon(dot)asher(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres friendly RegEx?
Date: 2006-12-12 21:44:01
Message-ID: 25220.1165959841@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Jon Asher" <jon(dot)asher(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeremy Harris 2006-12-12 22:54:36 Re: Postgres friendly RegEx?
Previous Message Tom Lane 2006-12-12 21:40:59 Re: a question on SQL