Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] concatenation of string literals - Mailing list pgsql-general

From Guido Piazzi
Subject Re: [GENERAL] concatenation of string literals
Date
Msg-id Pine.LNX.3.96.980718171448.130C-100000@ik2gdx.ampr.org
Whole thread Raw
In response to concatenation of string literals  (Kurt Seel <kseel@utcorp.com>)
List pgsql-general
Tree view 
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
------------------------------------------------------------------------

pgsql-general by date:

Previous
From: Maarten Boekhold
Date:
Subject: Re: [GENERAL] PERL Interface - upgrade from 6.2.1 to 6.3.2
Next
From: Michael
Date:
Subject: Boy I hate upgrades..Cannot connect locally