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