On 2010-09-15 15:33, Tom Lane wrote:
=?ISO-8859-1?Q?Johannes_=D6berg?= writes:
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.
Well, the symptom as described seems pretty improbable. You didn't
=?ISO-8859-1?Q?Johannes_=D6berg?= 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 new
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 bt