Postgres 15

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE newtable (
  id int PRIMARY KEY
, name text
);

INSERT INTO newtable VALUES
  (1, 'poleć')
, (2, 'poleć')
;
2 rows affected

UPDATE newtable t
SET    name = u.new_name
FROM  (
   SELECT DISTINCT ON (new_name) *  -- one per group, unchanged first
   FROM  (
      SELECT id, name
           , translate(regexp_replace(trim(name), '\s\s+', ' ', 'g')
                     , 'ąćęłńóśźżĄĆĘŁŃÓŚŹŻ'
                     , 'acelnoszzACELNOSZZ') AS new_name
      FROM   newtable
      ) sub
   ORDER  BY new_name, name <> new_name, id
   ) u
WHERE u.id = t.id
AND   u.name <> u.new_name;  -- only if actual change
1 rows affected

TABLE newtable;


id
name


2
poleć

1
polec