From 0817201580fe29bc925cb0bf113f14dd5a9f639e Mon Sep 17 00:00:00 2001 From: Jean-Marc Pigeon Date: Fri, 14 Nov 2025 10:34:52 -0500 Subject: [PATCH] chatgtp est vraiment perdu! --- sql/mailleur.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/sql/mailleur.sql b/sql/mailleur.sql index 76f2963..0447e8d 100644 --- a/sql/mailleur.sql +++ b/sql/mailleur.sql @@ -177,8 +177,8 @@ CREATE FUNCTION updpass() RETURNS trigger AS $$ DECLARE skip BOOLEAN := FALSE; BEGIN - SELECT COALESCE(MAX(skip_password_trigger),FALSE) INTO skip - FROM temp_skip_flag; + SELECT skip_password_triggerINTO skip + FROM temp_skip_flag limit 1; IF skip = FALSE THEN NEW.hash = md5(HASHING); NEW.password = crypt (NEW.password,gen_salt('md5')); -- 2.47.3