Recently, I learnt that you can concatenate string in PostgreSQL using ||
instead of relying of CONCAT
function. For example,
SELECT firstname || ' ' || lastname
FROM users;
Tags: sql postgresql
Recently, I learnt that you can concatenate string in PostgreSQL using ||
instead of relying of CONCAT
function. For example,
SELECT firstname || ' ' || lastname
FROM users;
Tags: sql postgresql