You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
47 lines
837 B
47 lines
837 B
return: text
|
|
lang: plpgsql
|
|
src: |
|
|
DECLARE result TEXT;
|
|
BEGIN
|
|
EXECUTE 'DROP TABLE IF EXISTS w_tmp;';
|
|
|
|
EXECUTE 'CREATE TEMP TABLE w_tmp AS
|
|
SELECT
|
|
t_ages.oid,
|
|
t_ages.code,
|
|
t_ages.texte
|
|
FROM base.t_ages
|
|
ORDER BY code;';
|
|
|
|
EXECUTE 'UPDATE
|
|
pmsi.t_ages_c
|
|
SET
|
|
code = w_tmp.code,
|
|
texte = w_tmp.texte
|
|
FROM
|
|
w_tmp
|
|
WHERE
|
|
t_ages_c.oid = w_tmp.oid
|
|
AND (
|
|
t_ages_c.code IS DISTINCT FROM w_tmp.code
|
|
OR t_ages_c.texte IS DISTINCT FROM w_tmp.texte
|
|
);';
|
|
|
|
EXECUTE 'INSERT INTO pmsi.t_ages_c (
|
|
oid,
|
|
code,
|
|
texte
|
|
)
|
|
SELECT w_tmp.oid,
|
|
w_tmp.code,
|
|
w_tmp.texte
|
|
FROM w_tmp
|
|
WHERE w_tmp.oid NOT IN (
|
|
SELECT oid
|
|
FROM pmsi.t_ages_c
|
|
)
|
|
ORDER BY w_tmp.code;';
|
|
|
|
RETURN 'OK';
|
|
|
|
END;
|