On Mon, 24 Nov 2003, Tom Lane wrote:
> Oleg Bartunov <[EMAIL PROTECTED]> writes:
> > seems for regexp which works in 7.3 is failing in 7.4.
> > Is't possible to configure pgsql to be compatible with 7.3 regexp ?
>
> SET regex_flavor TO extended;
aha, thanks a lot
>
> > www=# select 'problem' ~ '
Oleg Bartunov <[EMAIL PROTECTED]> writes:
> seems for regexp which works in 7.3 is failing in 7.4.
> Is't possible to configure pgsql to be compatible with 7.3 regexp ?
SET regex_flavor TO extended;
> www=# select 'problem' ~ '^\\p';
> ERROR: invalid regular expression: invalid escape \ sequence
