19.81 ms (46.86%)
|
1 |
SELECT DISTINCT titre,
regexp_replace(regexp_replace(LOWER(unaccent(titre)), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS titre_formate
FROM document
ORDER BY titre_formate ASC
SELECT DISTINCT titre,
regexp_replace(regexp_replace(LOWER(unaccent(titre)), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS titre_formate
FROM document
ORDER BY titre_formate ASC;
|
9.53 ms (22.54%)
|
1 |
SELECT
id,
CONCAT(prenom,' ',nom) AS identite,
regexp_replace(regexp_replace(LOWER(unaccent(CONCAT(prenom,' ',nom))), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS identite_formate
FROM personne
ORDER BY nom ASC, prenom ASC
SELECT
id,
CONCAT(prenom,' ',nom) AS identite,
regexp_replace(regexp_replace(LOWER(unaccent(CONCAT(prenom,' ',nom))), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS identite_formate
FROM personne
ORDER BY nom ASC, prenom ASC;
|
7.09 ms (16.78%)
|
1 |
SELECT
id,
libelle_fr,
libelle_en,
regexp_replace(regexp_replace(LOWER(unaccent(libelle_fr)), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS libelle_fr_formate,
regexp_replace(regexp_replace(LOWER(unaccent(libelle_en)), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS libelle_en_formate
FROM mot_cle
ORDER BY libelle_fr_formate
SELECT
id,
libelle_fr,
libelle_en,
regexp_replace(regexp_replace(LOWER(unaccent(libelle_fr)), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS libelle_fr_formate,
regexp_replace(regexp_replace(LOWER(unaccent(libelle_en)), '[[:punct:]]', '', 'g'), '^\s+', '', 'g') AS libelle_en_formate
FROM mot_cle
ORDER BY libelle_fr_formate;
|