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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2000-10-19 01:40:00 Re: data dictionary?
Previous Message D. Duccini 2000-10-18 20:16:37 Re: data dictionary?