Re: Migrating between versions. Problem with regexp

From: Kaloyan Iliev Iliev <news1(at)faith(dot)digsys(dot)bg>
To: pgsql-general(at)postgresql(dot)org
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Migrating between versions. Problem with regexp
Date: 2004-08-29 15:17:13
Message-ID: 4131F379.4080207@faith.digsys.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thank you
Kaloyan

Tom Lane wrote:

>Kaloyan Iliev Iliev <news1(at)faith(dot)digsys(dot)bg> 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
>
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kaloyan Iliev Iliev 2004-08-29 16:12:26 Re: Migrating between versions. Problem with regexp
Previous Message Tom Lane 2004-08-29 14:14:53 Re: Migrating between versions. Problem with regexp