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