Re: View fields are cast as text and link to Access as a Memo field - Mailing list pgsql-general

Karen Springer <karen.springer@wulfsberg.com> writes:
> I need employeeName to be a text field in Access.  I have tried casting
> the fields in the view as varchar, but it seem to default back to ::text.

The result of a || operator is always going to be type text.  Put the
cast around the whole expression, not just the individual fields.
For instance,

        CASE
            WHEN "Participant_Names"."NameUsed" IS NULL THEN
("Participant_Names"."LastNAME" || ', ') || "Participant_Names"."FirstName"
            ELSE ("Participant_Names"."LastNAME" || ', ') || "Participant_Names"."NameUsed"
        END :: varchar AS "employeeName"

            regards, tom lane