On Tue, Dec 13, 2011 at 7:51 AM, InterRob <rob.mar...@gmail.com> wrote: > Thanks guys, i see what you mean. > > I do intend to use the PG escaping, in order to avoid that annoying > warning... Hence, my expression should indeed be: > SELECT regexp_matches('123-A' , E'(3[A-Z\\-\\(\\) ])'); > > In the above expression i added the parentheses as I whish to match these as > well :))
I advise dollar quoting when writing complicated regular expressions: E'(3[A-Z\\-\\(\\) ])' becomes $$(3[A-Z\-\(\) ])$$ merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general