Force ARE in regexp string - Mailing list pgsql-general

From Johannes Öberg
Subject Force ARE in regexp string
Date
Msg-id 4C908FCE.2080109@proactivegaming.com
Whole thread Raw
Responses Re: Force ARE in regexp string  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
  Hi! I'm trying to do an advanced regexp match but postgres doesn't
seem to let me.

I've set regex_flavor to ARE, and I've tried prefixing my strings, i.e.
~* E'***:abc' but for some reason postgres treats all my regexps as BRE's.

Common newbie gotchas? I'm trying it directly from psql.exe btw, running
postgres 8.4 on a professionally set up Linux machine, and I've also
tried it locally on a Windows Bitnami machine with the same results.

Thank
/J

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: workaround steps for autovaccum problem
Next
From: Peter Roethlisberger
Date:
Subject: configure: error: header file is required for XML support