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 8: explain analyze is your friend
