END IF;
-- Ajout d'une colonne the_confidentiel à la table theme
- IF NOT EXISTS (SELECT 1 FROM information_schema.tables
+ IF NOT EXISTS (SELECT 1 FROM information_schema.columns
WHERE table_schema = 'notes' AND
table_name = 'theme' AND
column_name = 'the_confidentiel') THEN
AND (eve_debut BETWEEN p_start AND p_end OR eve_fin BETWEEN p_start AND p_end)
AND (prm_grp_id ISNULL OR prm_grp_id = personne_groupe.grp_id)
AND (prm_per_ids ISNULL OR event_personne.per_id = ANY(prm_per_ids))
- AND (events.ety_id ISNULL OR events.ety_id = event.ety_id)) sub
- AND (NOT events.evs_locked OR events_statut.sta_id = personne_info_integer_get(prm_token, event_personne.per_id, 'statut_usager'))
+ AND (events.ety_id ISNULL OR events.ety_id = event.ety_id)
+ AND (NOT events.evs_locked OR events_statut.sta_id = personne_info_integer_get(prm_token, event_personne.per_id, 'statut_usager'))
+ ) sub
GROUP BY
eca_nom,
ety_id,
UPDATE liste.liste SET lis_nom = prm_nom, lis_code = pour_code (prm_code), ent_id = prm_ent_id, lis_inverse = prm_inverse, lis_pagination_tout = prm_pagination_tout, lis_locked = prm_lis_locked WHERE lis_id = prm_lis_id;
END;
$$;
-COMMENT ON FUNCTION liste_liste_update(prm_token integer, prm_lis_id integer, prm_nom character varying, prm_code varchar, prm_ent_id integer, prm_inverse boolean, prm_pagination_tout boolean, prm_lis_locked boolean IS
+COMMENT ON FUNCTION liste_liste_update(prm_token integer, prm_lis_id integer, prm_nom character varying, prm_code varchar, prm_ent_id integer, prm_inverse boolean, prm_pagination_tout boolean, prm_lis_locked boolean) IS
'Modifie les informations d''une configuration de page liste.';
CREATE OR REPLACE FUNCTION liste_supp_edit (prm_token integer, prm_cha_id integer, prm_inf_ids integer[])