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;"
Try:
psql -c " select (arcode || '-') || phnum from nccbor_member;"
Regards,
------------------------------------------------------------------------
// Guido Carlo Piazzi Accompagnatore naturalistico
// gpiazzi@nemo.it Visitate il sito WWW.ParcoDelTicino.Pmn.It
------------------------------------------------------------------------