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

Re: Stupid question: concatenating strings

From: Thomas Good <tomg(at)q8(dot)nrnet(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: justinlong(at)strategicnetwork(dot)org, pgsql-novice(at)hub(dot)org
Subject: Re: Stupid question: concatenating strings
Date: 2000-10-19 16:09:53
Message-ID: Pine.LNX.3.96.1001019120511.8283B-100000@q8.nrnet.org (view raw or flat)
Thread:
Lists: pgsql-novice
On Wed, 18 Oct 2000, Tom Lane wrote:

> 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 ...

Roger that - I did and installed 7.0.2 this morning.  As usual the
build went fine and to my amazement the versions of DBI and DBD
I had in place seem to work fine also!  (It did take me awhile to
locate and install the pg man pages...but I got there.)

I do have a silly question tho:  On RH 6.1 Linux the pg tarballs
that come from Lamar O. are 6.5.2.  And they work fine - in fact
there is a command history function in psql that I like alot being
a bash user - even on FBSD and UnixWare.

Yet, I can't get command hx to work for 7.0.2 psql (on slackware 3.6).
Am I not seeing something obvious here?

TIA,
Tom Good

> Yes, || is marked left-associative in more recent versions.
> 
> regression=# select 'a' || 'b' || 'c';
>  ?column?
> ----------
>  abc
> (1 row)
> 
> 			regards, tom lane


--------------------------------------------------------------------
               SVCMC - Center for Behavioral Health                  
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
IS Coordinator / DBA                 Phone: 718-354-5528 
                                     Fax:   718-354-5056  
--------------------------------------------------------------------
Powered by:  PostgreSQL     s l a c k w a r e          FreeBSD:
               RDBMS       |---------- linux      The Power To Serve
--------------------------------------------------------------------


In response to

Responses

pgsql-novice by date

Next:From: D. DucciniDate: 2000-10-19 16:17:11
Subject: Re: changing data type
Previous:From: bmccoyDate: 2000-10-19 15:37:52
Subject: Re: changing data type

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