Re: Stupid question: concatenating strings - Mailing list pgsql-novice

From Tom Lane
Subject Re: Stupid question: concatenating strings
Date
Msg-id 6886.971918329@sss.pgh.pa.us
Whole thread Raw
In response to Re: Stupid question: concatenating strings  (Thomas Good <tomg@q8.nrnet.org>)
Responses Re: Stupid question: concatenating strings  (Thomas Good <tomg@q8.nrnet.org>)
List pgsql-novice
Thomas Good <tomg@q8.nrnet.org> writes:
> The || operator needs parentheses to concat > 2 items in Pg 6.3.2.
> Has this been fixed in subsequent versions?

You're still on 6.3.2?  Run, do not walk, to your nearest archive
site for an update ...

Yes, || is marked left-associative in more recent versions.

regression=# select 'a' || 'b' || 'c';
 ?column?
----------
 abc
(1 row)

            regards, tom lane

pgsql-novice by date:

Previous
From: "D. Duccini"
Date:
Subject: Re: data dictionary?
Next
From: Tom Lane
Date:
Subject: Re: data dictionary?