I'm new to PostgreSQL and I'm trying to figure out what does the operator || mean?

Google didn't help with that...

closed as off-topic by Erwin Brandstetter, Colin 't Hart, Vérace, Michael Green, Mark Sinkinson Jun 18 '15 at 13:32

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Erwin Brandstetter, Colin 't Hart, Vérace, Michael Green, Mark Sinkinson
If this question can be reworded to fit the rules in the help center, please edit the question.

  • postgresql.org/docs/9.4/static/index.html - worth reading. This you will find in several sections of 9. Functions and Operators – dezso Jun 3 '15 at 14:02
  • 1
    It's the standard SQL operator to concatenate strings. – a_horse_with_no_name Jun 3 '15 at 14:03
  • 2
    ... and in PostgreSQL, concatenate tsvectors, OR tsquerys together, array-to-array concatenation, element-to-array concatenation and array-to-element concatenation. – dezso Jun 3 '15 at 14:06

String concatenation as you can see here: http://www.postgresql.org/docs/9.4/static/functions-string.html

Array concatenation: http://www.postgresql.org/docs/9.4/static/functions-array.html

And others... It means: concatenation.

Not the answer you're looking for? Browse other questions tagged or ask your own question.