COMPOSE

PostgreSQL

Example

SELECT
  COMPOSE('%' || 'hello' || '%');

Output

  compose
-----------
 %hello%
(1 row)

Explanation

In the example, the COMPOSE function is used to concatenate a string with % characters on both sides, producing %hello%. Immediately following the COMPOSE function is (1 row), which indicates that the function successfully returned one row of output.