
SELECT
  (COALESCE(nom,'') || ' ' || COALESCE(marital,'') || ' ' || COALESCE(prenom,'')) as nom,
  to_char(datenaissance,'DD/MM/YYYY') as naissance,
  to_char(dateinhumation,'DD/MM/YYYY') as dateinhumation,
  nature,
  taille,
  reduction,
  exhumation

FROM
  &DB_PREFIXEdefunt

WHERE
  emplacement=&idx
;
