UPDATE dev.model_file_to_verification
SET fbytes = convert_to(
replace(
convert_from(fbytes, 'UTF8'),
'НомерЗапр="' || (
SELECT "number"::text
FROM report.smev_register
WHERE id = :smevRegisterId
) || '"',
'НомерЗапр="' || :new_number || '"'
),
'UTF8'
)
WHERE id = (
SELECT model_file_to_verification_id
FROM report.fns_reference_request_journal
WHERE smevregisterid = :smevRegisterId
LIMIT 1
)
#if ($db.eval("select count(1) from report.smev_register
where ""number"" = ':new_number'
and id != :smevRegisterId") > 0)
$messages.error("Запрос с таким номером уже существует")
#end