Vol. I · A Postgres Handbook

The Query & the Schema

A reading-room reference for writing PostgreSQL by hand — selects to window functions, with the schema in plain view.

EasyString Functions

CONCAT and || operator for string building

The query

SQL
SELECT
  CONCAT(first_name, ' ', last_name) AS full_name,
  first_name || ' ' || last_name AS concat_with_op,
  CONCAT_WS(', ', last_name, first_name) AS formal_name
FROM employees;
Tested against PostgreSQL 16

Note

“CONCAT_WS (with separator) skips NULLs automatically. || propagates NULLs.

Tables referenced