Anonymous

CREATE OR REPLACE VIEW techniques.vue_maides AS 
 SELECT maials.alsdes AS dest, maials.alsnom AS nom, vue_domcur.domnomlon AS "domain"
   FROM techniques.maials
   JOIN techniques.vue_domcur ON vue_domcur.domcod = maials.domcod
  WHERE maials.domcod IS NOT NULL
UNION 
 SELECT (mai.mainom::text || '@'::text) || vue_domcur.domnomlon AS dest, mai.mainom AS nom, vue_domcur.domnomlon AS "domain"
   FROM techniques.mai
   JOIN techniques.vue_domcur ON vue_domcur.domcod = mai.domcod
  WHERE true;