UPDATE `address` AS `a1`
JOIN (
SELECT MIN(`id`) AS `id` FROM `address` GROUP BY `organizationfk`
) AS `a2` ON `a2`.`id` = `a1`.`id`
LEFT JOIN (
SELECT `organizationfk` FROM `address` WHERE `primary` = 1
) AS `a3` ON `a3`.`organizationfk` = `a1`.`organizationfk`
SET `a1`.`primary` = 1
WHERE `a3`.`organizationfk` IS NULL
update address a
set a."primary" = q1.is_primary
from (
select
id
,(row_number() over (partition by organizationfk order by nullif("primary", false))) = 1 is_primary
from address
) q1
where q1.id=a.id
Я имею ввиду отдельные маленькие проекты.Звучит похоже на микросервисы.
/(?<![\.\d])\d+(?![\.\d])/