Hi,

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 ?

Welcome to psql 7.3.4, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

discovery=#  select 'problem' ~ '^\\p';
 ?column?
----------
 t
(1 row)


Welcome to psql 7.4, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

www=# select 'problem' ~ '^\\p';
ERROR:  invalid regular expression: invalid escape \ sequence


	Regards,
		Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Mon, 24 Nov 2003 20:38:16 +0300 (MSK)
Oleg Bartunov <oleg@sai.msu.su>
regexp incompatibilites 7.3 and 7.4
Oleg Bartunov <oleg@sai.msu.su> 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

I think, though, that this is telling you about a bug in your
application.  You do realize that under extended regex rules there's
no difference between that pattern and '^p' ?  Is that *really* what
you want?

			regards, tom lane

Mon, 24 Nov 2003 12:53:26 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: regexp incompatibilites 7.3 and 7.4 
On Mon, 24 Nov 2003, Tom Lane wrote:

> Oleg Bartunov <oleg@sai.msu.su> 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' ~ '^\\p';
> > ERROR:  invalid regular expression: invalid escape \ sequence
>
> I think, though, that this is telling you about a bug in your
> application.  You do realize that under extended regex rules there's
> no difference between that pattern and '^p' ?  Is that *really* what
> you want?


Actually, we have old application which uses perl function quotemeta()
which escaped any cyrillic characters. I used in example latin characters
for simplicity. I  have to use double backslash in psql only.



>
> 			regards, tom lane
>

	Regards,
		Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Mon, 24 Nov 2003 23:45:29 +0300 (MSK)
Oleg Bartunov <oleg@sai.msu.su>
Re: regexp incompatibilites 7.3 and 7.4 