Re: Varchar concatenate fields as Char or Varchar, not Text

[MargaretGillon@xxxxxxxxxxxxxx]

>"Uwe C. Schroeder" <uwe@xxxxxxxxx>
wrote on 08/07/2006 11:30:28 AM:
> Well, you cast all those fields to be concatenated to text. Why should
the db 
> make a varchar out of that? I seriously doubt that 7.x made a varchar
of that 
> - but then, 7.2 is very very old.
> So either cast your fields to varchar (i.e. c.refullname::varchar
|| 
> d.enname::varchar) or cast the result of the concatenation to a varchar.
> 
> UC

FYI in 8.1.4 if the cast is changed to varchar the
result still comes out as a text field
>> SELECT (c.refullname::varchar || d.enname::varchar
|| f.evname::varchar) AS evlinkname1, 
results in evlinkname1 as text

Margaret Gillon