This looks like it does what you want...
processdata=> select version();
version
---------------------------------------------------------------
PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.95.4
(1 row)
processdata=> update my_table set codlm = ('22' || substring(codlm, 3))
where codlm like '45%';
UPDATE 3
I think that I need an update for Postgres!
On PostgreSQL 6.5 on i686-pc-linux-gnu, compiled by gcc egs-2.91.66 do not
work!
Thank you very much!
