Horton

Re: Stupid question: concatenating strings

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Thomas Good <tomg@q8.nrnet.org>
Cc: justinlong@strategicnetwork.org, pgsql-novice@hub.org
Date: 2000-10-19T01:18:49Z
Lists: 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