Update a geometry for a translation

UPDATE g_comuni SET geom = ST_Translate(geom, -0.001187, -0.001223) WHERE cca = '19'

The units used for the translation must be the ones defined in the SRS.