Re: Varchar concatenate fields as Char or Varchar, not Text

From: MargaretGillon(at)chromalloy(dot)com
To: Rodrigo Gonzalez <rjgonzale(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Varchar concatenate fields as Char or Varchar, not Text
Date: 2006-08-07 18:39:15
Message-ID: OF710A0991.2EF5203A-ON882571C3.00665902-882571C3.006678E5@CHROMALLOY.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>Rodrigo Gonzalez <rjgonzale(at)gmail(dot)com> wrote on 08/07/2006 11:36:28 AM:
> Really, I dont see the 3 varchar fields concatenated to a new field.
>
> But do this....
>
> (varchar1||varchar2||varchar3||newfield)::varchar
>
> Best regards
>

This is the concatenate statement

> > SELECT b.ltname, (c.refullname::text || d.enname::text) ||
> > f.evname::text AS evlinkname1,

Margaret Gillon

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rodrigo Gonzalez 2006-08-07 18:41:52 Re: Varchar concatenate fields as Char or Varchar, not
Previous Message Rodrigo Gonzalez 2006-08-07 18:36:28 Re: Varchar concatenate fields as Char or Varchar, not