Varchar concatenate fields as Char or Varchar, not Text

From: MargaretGillon(at)chromalloy(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Varchar concatenate fields as Char or Varchar, not Text
Date: 2006-08-07 18:20:01
Message-ID: OF1B69BC8C.A611CE50-ON882571C3.0063F07A-882571C3.0064B654@CHROMALLOY.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Last week I upgraded to postgresql 8.1.4 (YEAH!) In my database I have a
view which concatenates three varchar fields to a new field. With
postgresql 7.2.3 the field resulting from the concatenation was a varchar,
with postgresql 8.1.4 the new field is a text field. This is affecting all
kinds of forms in my application. Is there a way I can get the output as
char or varchar? View code is below.

CREATE OR REPLACE VIEW vweventsummary AS
SELECT b.ltname, (c.refullname::text || d.enname::text) || f.evname::text
AS evlinkname1,
(g.refullname::text || h.enname::text) || i.evname::text AS evlinkname2,
a.evid, a.evlinktype, a.eventity1, a.evevent1, a.evresource1, a.eventity2,
a.evevent2, a.evresource2
FROM event a, linktype b, resource c, entity d, event f, resource g,
entity h, event i
WHERE a.evlinktype = b.ltid AND a.evevent1 = f.evid AND
a.evevent2 = i.evid AND a.evresource1 = c.reid
AND a.evresource2 = g.reid AND a.eventity1 = d.enid AND a.eventity2 =
h.enid;

*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
*** ***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297

This e-mail message and any attachment(s) are for the sole use of the
intended recipient(s) and may contain proprietary and/or confidential
information which may be privileged or otherwise protected from
disclosure. Any unauthorized review, use, disclosure or distribution is
prohibited. If you are not the intended recipient(s), please contact the
sender by reply email and destroy the original message and any copies of
the message as well as any attachment(s) to the original message.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Uwe C. Schroeder 2006-08-07 18:30:28 Re: Varchar concatenate fields as Char or Varchar, not Text
Previous Message Steve Crawford 2006-08-07 18:10:47 psql: absolutes and toggles