Decode is a simple function inspired by Oracle's decode function, useful for creating queries that work on both Oracle and PostgreSQL. concat(...) concatinates multiple strings into one string.
pgsql-hackers by date:
Соглашаюсь с условиями обработки персональных данных