Concatenate attributes

PL/pgSQL

SELECT ARRAY_TO_STRING(ARRAY[title, firstname, surname], ' ') FROM persons;