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 !