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

Поиск
Список
Период
Сортировка
От MargaretGillon@chromalloy.com
Тема Re: Varchar concatenate fields as Char or Varchar, not Text
Дата
Msg-id OF04501FD3.E68B1442-ON882571C3.0065EAE9-882571C3.0068E51B@CHROMALLOY.COM
обсуждение исходный текст
Ответ на Re: Varchar concatenate fields as Char or Varchar, not Text  ("Uwe C. Schroeder" <uwe@oss4u.com>)
Список pgsql-general
Дерево обсуждения

"Uwe C. Schroeder" <uwe@oss4u.com> 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Practical maximums (was Re: PostgreSQL theoretical
Следующее
От: MargaretGillon@chromalloy.com
Дата:
Сообщение: Re: Varchar concatenate fields as Char or Varchar, not Text