=?ISO-8859-1?Q?Johannes_=D6berg?= <johannes.oberg@xxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
