Re: Force ARE in regexp string

=?ISO-8859-1?Q?Johannes_=D6berg?= <johannes(dot)oberg(at)proactivegaming(dot)com> writes:
> 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?

Well, the symptom as described seems pretty improbable. You didn't show
an exact example, but I'm suspecting the real problem is that you're not
allowing for backslashes in a string literal getting eaten by string
parsing. Do the cases that don't work for you involve backslashes in
the regex?

regards, tom lane