concatenation of string literals - Mailing list pgsql-general

From Kurt Seel
Subject concatenation of string literals
Date
Msg-id 35AF6D63.63DABEB6@utcorp.com
Whole thread Raw
Responses Re: [GENERAL] concatenation of string literals  (eric@gateway.ctlno.com)
Re: [GENERAL] concatenation of string literals  (Guido Piazzi <gpiazzi@nemo.it>)
List pgsql-general
This works :
psql -c "select arcode ||  phnum from nccbor_member;"

 But this doesn't
psql -c " select arcode || '-' || phnum from nccbor_member;"

 It's an inconvience because I am doing mail merges in wordperfect
using postodbc, and I keep having to do things like put dashes in
phone numbers and such in wordperfect, is there another way to concat
string literals?

--
Kurt Seel, Systems Engineer
Unified Technologies Corp.
Phone : 610 964 8200
Email : kseel@ut{anti-spam]corp.com

 To send me email, remove the {anti-spam] from the above address.

pgsql-general by date:

Previous
From: "J. Christopher Bower"
Date:
Subject: Porting from 6.1 to 6.3.2 - 6.1 pgdump Segv Fault
Next
From: Konstantinos Vassiliadis
Date:
Subject: Loading shared object files into Postgres