String Concatenation Operator Type Resolution : String Concatenate « Postgre SQL « PostgreSQL






  1. PostgreSQL
  2. Postgre SQL
  3. String Concatenate

String Concatenation Operator Type Resolution


postgres=# -- String Concatenation Operator Type Resolution
postgres=#
postgres=# SELECT text 'abc' || 'def' AS "text and unknown";
 text and unknown
------------------
 abcdef
(1 row)

postgres=#
postgres=#








Related examples in the same category

1.Using operators with NULL values
2.SELECT 'abc' || 'def'
3.Concatenating strings