Re: [GENERAL] 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.
> >
>
> 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

My guess is you have to cast the '-' to text and that postgresql at the
moment sees '-' as a char:

select arcode || '-'::text || phnum from nccbor_members

Maarten

_____________________________________________________________________________
| TU Delft, The Netherlands, Faculty of Information Technology and Systems  |
|                   Department of Electrical Engineering                    |
|           Computer Architecture and Digital Technique section             |
|                          M.Boekhold@et.tudelft.nl                         |
-----------------------------------------------------------------------------