Postgres Pro
Downloads
Home   >   mailing lists

regexp_replace grief - Mailing list pgsql-admin

From Armin Resch
Subject regexp_replace grief
Date
Msg-id CAGo0LBT2ihUM=v8e-rd0CvZxc8BF3VfrYB75zW+vP4Jm9UkHaQ@mail.gmail.com
Whole thread Raw
Responses Re: regexp_replace grief  (Craig James <cjames@emolecules.com>)
Re: regexp_replace grief  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-admin
Tree view
Not sure this is the right list to vent about this but here you go:

I) select regexp_replace('BEFORE.AFTER','(.*)\..*','\1','g') "Substring"
II) select regexp_replace('BEFORE.AFTER','(.*)\\..*','\\1','g') "Substring"

Executing (II) against pg 8.4.4 or 9.0.4 yields 'BEFORE', but in order for 9.1.7 to yield the same one has to execute (I) .. bummer

-ar

pgsql-admin by date:

Previous
From: Nik Tek
Date:
Subject: Re: Postgres log(pg_logs) have lots of message
Next
From: Craig James
Date:
Subject: Re: regexp_replace grief