Re: What is || doing - Mailing list pgsql-novice

From Tim Landscheidt
Subject Re: What is || doing
Date
Msg-id m3y60nmmzj.fsf@passepartout.tim-landscheidt.de
Whole thread Raw
In response to What is || doing  (Frank Lanitz <frank@frank.uvena.de>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Frank Lanitz
Date:
Subject: Re: What is || doing
Next
From: matty jones
Date:
Subject: Re: Database organization questions