Re: [GENERAL] concatenation of string literals

From: Guido Piazzi <gpiazzi(at)nemo(dot)it>
To: Kurt Seel <kseel(at)utcorp(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] concatenation of string literals
Date: 1998-07-18 15:19:27
Message-ID: Pine.LNX.3.96.980718171448.130C-100000@ik2gdx.ampr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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(at)nemo(dot)it Visitate il sito WWW.ParcoDelTicino.Pmn.It
------------------------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael 1998-07-18 17:16:49 Boy I hate upgrades..Cannot connect locally
Previous Message Maarten Boekhold 1998-07-18 10:48:57 Re: [GENERAL] PERL Interface - upgrade from 6.2.1 to 6.3.2