Thread: update with RE

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 !

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.