   AND n.id_parent <> 0
   AND n.actif = true;
 --USAGE : 
---SELECT * FROM nomenclatures.v_statut_valid;+--SELECT * FROM nomenclatures.v_statut_valid;

    date_create timestamp without time zone DEFAULT now(),
    date_update timestamp without time zone DEFAULT now()
);
COMMENT ON TABLE bib_types_nomenclatures IS 'Description de la liste des nomenclatures du SINP.';

CREATE TABLE t_nomenclatures (
    id_nomenclature integer NOT NULL,

CREATE FUNCTION get_filtered_nomenclature(idtype integer, myregne character varying, mygroup character varying) RETURNS SETOF integer
    LANGUAGE plpgsql IMMUTABLE
    AS $$
--Function that returns a list of id_nomenclature depending on regne and/or group2_inpn sent with parameters.
  DECLARE
    thegroup character varying(255);
    theregne character varying(255);
