What is || doing

From: Frank Lanitz <frank(at)frank(dot)uvena(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: What is || doing
Date: 2011-06-27 12:59:30
Message-ID: 4E087EB2.3030500@frank.uvena.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi list,

I've got an query which contains || inside the select statement and I'm
not sure, what this is doing. Can you help me out a bit or send me a
link to documentation where I can find this?

Example:

SELECT 'ba_'|| foo || '_pr_'
FROM 'foobaa'
WHERE id=1234;

Cheers,
Frank

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Thom Brown 2011-06-27 13:12:08 Re: What is || doing
Previous Message SamuelStar 2011-06-25 12:49:37 A problematic query