regexp_replace grief

From: Armin Resch <reschab(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: regexp_replace grief
Date: 2013-04-10 23:59:29
Message-ID: CAGo0LBT2ihUM=v8e-rd0CvZxc8BF3VfrYB75zW+vP4Jm9UkHaQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Craig James 2013-04-11 01:08:51 Re: regexp_replace grief
Previous Message Nik Tek 2013-04-10 22:05:55 Re: [ADMIN] Postgres log(pg_logs) have lots of message