concatenation of string literals

Поиск
Список
Период
Сортировка
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 по дате отправления: