BEGIN
PERFORM login._token_assert (prm_token, TRUE, FALSE);
mdp := 'password';
- WHILE mdp !~ '[-\!#\$%\*\+:<=>\?@\/]+' OR mdp !~ '[a-z]+' OR mdp !~ '[A-Z]+' OR mdp !~ '[0-9]+' OR char_length(mdp) != 8 LOOP
- SELECT string_agg (substr('abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789!#$%*+-:<=>?@', ceil (random() * 88)::integer, 1), '') INTO mdp FROM generate_series(1, 8);
+ WHILE mdp !~ '[-\!#\$%\*\+:=\?@\/]+' OR mdp !~ '[a-z]+' OR mdp !~ '[A-Z]+' OR mdp !~ '[0-9]+' OR char_length(mdp) != 8 LOOP
+ SELECT string_agg (substr('abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789!#$%*+-:=?@', ceil (random() * 88)::integer, 1), '') INTO mdp FROM generate_series(1, 8);
END LOOP;
INSERT INTO login.utilisateur (uti_login, per_id, uti_salt, uti_pwd, uti_config, uti_root, uti_email) VALUES (prm_login, prm_per_id, crypt (mdp, gen_salt('des')), mdp, prm_uti_config, prm_uti_root, prm_email) RETURNING uti_id INTO ret;
RETURN ret;
groupe.grp_id,
groupe.eta_id,
etablissement.eta_nom,
+ adresse.adr_adresse,
+ adresse.adr_cp,
+ adresse.adr_ville,
groupe.grp_nom,
personne_groupe.peg_debut,
personne_groupe.peg_fin,
INNER JOIN groupe_secteur USING(grp_id)
INNER JOIN meta.secteur USING(sec_id)
INNER JOIN personne_groupe USING (grp_id)
+ INNER JOIN adresse USING (adr_id)
where peg_id = prm_peg_id ;
RETURN row;
END;