Postgres Pro
Downloads
Home   >   mailing lists

Re: Regexp confusion - Mailing list pgsql-general

From Tom Lane
Subject Re: Regexp confusion
Date
Msg-id 12336.1255146988@sss.pgh.pa.us
Whole thread Raw
In response to Re: Regexp confusion  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Tree view 
Alvaro Herrera <alvherre@commandprompt.com> writes:
> I think the confusion is about what SIMILAR TO supports.  ? it doesn't.

Actually, upon looking into SQL:2008, it seems it's supposed to support
? now, and also {m,n} style bounds.  Those weren't there in SQL99 ...

I've changed the similar_escape code to not escape ? and {, so that
those things will work now, and to escape ^ and $ instead.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: transaction ID wraparound - should I use 'VACUUM' or 'VACUUM FULL' ?
Next
From: Robert Treat
Date:
Subject: Volunteers needed to help staff the PostgreSQL Booth at LISA 2009