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 OF4EFF5E63.F0BAA684-ON882571C3.0066DD1D-882571C3.0067DC6D@CHROMALLOY.COM
Whole thread Raw
In response to 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:41:52 AM:

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

This worked, thank you.
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Practical maximums (was Re: PostgreSQL theoretical
Next
From: Scott Marlowe
Date:
Subject: Re: Practical maximums (was Re: PostgreSQL theoretical