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.