Thomas Good <tomg(at)q8(dot)nrnet(dot)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';
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2000-10-19 01:40:00|
|Subject: Re: data dictionary? |
|Previous:||From: D. Duccini||Date: 2000-10-18 20:16:37|
|Subject: Re: data dictionary?|