Re: [GENERAL] Migrating between versions. Problem with regexp

[Kaloyan Iliev Iliev]

Thank you
    Kaloyan

Tom Lane wrote:
Kaloyan Iliev Iliev <[EMAIL PROTECTED]> writes:
 

libvar=# select '\\a\\à\\à\\.' ~ '\\a\\à\\à\\.';
ERROR:  invalid regular expression: invalid escape \ sequence
   

7.4 and later are stricter about the use of \ than prior versions; see 
http://www.postgresql.org/docs/7.4/static/functions-matching.html#POSIX-ESCAPE-SEQUENCES
You could go back to (approximately) the old behavior by changing
regex_flavor to "extended".

                        regards, tom lane
 

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
              http://archives.postgresql.org