MySQLとPostgreSQLで文字列結合する

MySQL, PostgreSQL9.1

SELECT CONCAT(t1.last_name, ' ', t1.first_name) FROM TURBINE_USER t1;

PostgreSQL9.1未満

SELECT (t1.last_name || ' ' || t1.first_name) FROM TURBINE_USER t1;