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:54:25
Message-ID: OF4EFF5E63.F0BAA684-ON882571C3.0066DD1D-882571C3.0067DC6D@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: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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2006-08-07 18:55:23 Re: Practical maximums (was Re: PostgreSQL theoretical
Previous Message Ron Johnson 2006-08-07 18:51:35 Re: Practical maximums (was Re: PostgreSQL theoretical