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