Re: [GENERAL] concatenation of string literals

On Fri, 17 Jul 1998, Kurt Seel wrote:

> 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(at)ut{anti-spam]corp(dot)com
>
> To send me email, remove the {anti-spam] from the above address.
>

You will probably need to put parenthases around either the first two or
the last two strings:

psql -c " select (arcode || '-') || phnum from nccbor_member;"

that should work fine