You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
9 lines
385 B
9 lines
385 B
src: |
|
|
SELECT p_personne.oid AS personne_id,
|
|
p_personne.matricule_courant AS personne_code,
|
|
((p_personne.nom || ' '::text) || p_personne.prenom::text) ||
|
|
CASE
|
|
WHEN p_personne.nom_naissance = ''::text THEN ''::text
|
|
ELSE (' (née '::text || p_personne.nom_naissance) || ')'::text
|
|
END AS personne_texte
|
|
FROM rh.p_personne;
|