Skip site navigation (1) Skip section navigation (2)

Re: Stupid question: concatenating strings

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Good <tomg(at)q8(dot)nrnet(dot)org>
Cc: justinlong(at)strategicnetwork(dot)org, pgsql-novice(at)hub(dot)org
Subject: Re: Stupid question: concatenating strings
Date: 2000-10-19 01:18:49
Message-ID: 6886.971918329@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
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';
 ?column?
----------
 abc
(1 row)

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2000-10-19 01:40:00
Subject: Re: data dictionary?
Previous:From: D. DucciniDate: 2000-10-18 20:16:37
Subject: Re: data dictionary?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group