Really, I dont see the 3 varchar fields concatenated to a new field.
But do this....
(varchar1||varchar2||varchar3||newfield)::varchar
Best regards
MargaretGillon@xxxxxxxxxxxxxx wrote:
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.
