ТРИГГЕР TRIGGER POSTGRES
CREATE OR REPLACE FUNCTION update_user_datas()
RETURNS trigger AS
$BODY$
BEGIN
UPDATE users_datas SET height = (SELECT height FROM users WHERE users.id = (SELECT user_id FROM users_datas ORDER BY id DESC LIMIT 1))
WHERE height IS NULL;
RETURN NULL;
END;
$BODY$ LANGUAGE plpgsql;

сперва создание процедуры
CREATE TRIGGER insert_user_height
AFTER INSERT ON users_datas
EXECUTE PROCEDURE update_user_datas()
 Дмитрий Плешанов
Дмитрий Плешанов 13:21
DROP TRIGGER insert_user_height on users_datas;
DROP FUNCTION update_user_datas();