Postgres Pro
Downloads
Home   >   mailing lists

Re: Varchar concatenate fields as Char or Varchar, not Text - Mailing list pgsql-general

From MargaretGillon@chromalloy.com
Subject Re: Varchar concatenate fields as Char or Varchar, not Text
Date
Msg-id OF710A0991.2EF5203A-ON882571C3.00665902-882571C3.006678E5@CHROMALLOY.COM
Whole thread Raw
In response to Re: Varchar concatenate fields as Char or Varchar, not  (Rodrigo Gonzalez <rjgonzale@gmail.com>)
Responses Re: Varchar concatenate fields as Char or Varchar, not  (Rodrigo Gonzalez <rjgonzale@gmail.com>)
List pgsql-general
Tree view

>Rodrigo Gonzalez <rjgonzale@gmail.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

pgsql-general by date:

Previous
From: "Uwe C. Schroeder"
Date:
Subject: Re: Varchar concatenate fields as Char or Varchar, not Text
Next
From: Rodrigo Gonzalez
Date:
Subject: Re: Varchar concatenate fields as Char or Varchar, not