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

I confirmed that 7.x created a varchar before I posted
the question to the list. If you doubt my statment I will provide screen
shots. I am still inexperienced with postgresql and am not sure what commands
such as cast can do/are doing which is why I posted the question to get
help. The view was written by another person. I did not know the concatenation
result could be cast or I would not have asked the question.

Regards,
*** *** *** *** *** *** *** *** ***
*** *** *** *** *** *** *** *** *** *** ***
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.