Decode is a simple function inspired by Oracle's decode function, useful forcreating queries that work on both Oracle and PostgreSQL.
concat(...) concatinates multiple strings into one string.