concatenation of string literals

Поиск
Список
Период
Сортировка
От Kurt Seel
Тема concatenation of string literals
Дата
Msg-id 35AF6D63.63DABEB6@utcorp.com
обсуждение исходный текст
Ответы Re: [GENERAL] concatenation of string literals  (eric@gateway.ctlno.com)
Re: [GENERAL] concatenation of string literals  (Guido Piazzi <gpiazzi@nemo.it>)
Список 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 по дате отправления:

Предыдущее
От: "J. Christopher Bower"
Дата:
Сообщение: Porting from 6.1 to 6.3.2 - 6.1 pgdump Segv Fault
Следующее
От: Konstantinos Vassiliadis
Дата:
Сообщение: Loading shared object files into Postgres