Re: update with RE - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: update with RE
Date
Msg-id 20011206140532.A22419@wolff.to
Whole thread Raw
In response to update with RE  (Vigny Christophe <cvigny@artprice.com>)
List pgsql-sql
On Mon, Dec 03, 2001 at 02:37:22PM +0100, Vigny Christophe <cvigny@artprice.com> wrote:
> hello,
> 
> Is it possible to use a Regular expression to update a field like in
> perl (s/T/t/)
> ie :
> update table set name=($1) where name ~* '.*(phe).*'
> substitute using a grouping function $1 is in fact 'phe'.
> 
> It should be really interesting and powerfull !

You would have to write a function to do this. There is a note about this
in the 7.2 documentation.


pgsql-sql by date:

Previous
From: Oleg Lebedev
Date:
Subject: view rules
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: view rules