Re: What is || doing

Frank Lanitz <frank@frank.uvena.de> wrote:

> 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;

It's a string concatenation, cf.
<URI:http://www.postgresql.org/docs/current/interactive/functions-string.html>.

Tim