From: | MargaretGillon(at)chromalloy(dot)com |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Concatenated VARCHAR becomes TEXT in view |
Date: | 2006-02-01 16:44:01 |
Message-ID: | OF07F1F7EE.6D9C73F3-ON88257108.005AA071-88257108.005B3978@CHROMALLOY.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have a view which I use to populate list boxes on several input screens
in Visual FoxPro for Windows. In the view I concatenate three varchar
columns to make a new column. The concatenation works fine but the
resulting column is a text column, which becomes a memo field in Visual
FoxPro. Memos don't work well for list boxes. Is there any way to get the
resulting column as a varchar or char field? My view command is below. I
have tried changing the ::text to ::varchar but the outcome is the same.
I am using Postgresql 7.3 running on Redhat Linux 9.
CREATE OR REPLACE VIEW vw_event_summary AS
SELECT b.ltname, ((btrim((c.refullname )::text) || btrim((d.enname
)::text)) || btrim((f.evname )::text)) AS evlinkname1,
((btrim((g.refullname )::text) || btrim((h.enname )::text)) ||
btrim((i.evname )::text)) AS evlinkname2, a.evid, a.evlinktype AS evltid,
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 ));
ALTER TABLE vw_event_summary OWNER TO postgres;
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
*** ***
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Frank Church | 2006-02-01 17:20:33 | Gotcha's in copying data between servers via file copy |
Previous Message | TJ O'Donnell | 2006-02-01 16:22:58 | Re: Converting Text to Bytea |