Re: [GENERAL] Force ARE in regexp string

2010-09-22 Thread Johannes Öberg
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

Re: [GENERAL] Force ARE in regexp string

2010-09-15 Thread Tom Lane
=?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

[GENERAL] Force ARE in regexp string

2010-09-15 Thread Johannes Öberg
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