Why "||" is used as string concatenation in PostgreSQL/Redshift

Viewed 16449

I find this really weird. If we will look at the major programming languages they all use "||" as logical "or" operator. Is there any (maybe historical) reason why "||" is living in PostgreSQL along with CONCAT() function?

1 Answers
Related