How to make silently truncate for char type

Поиск
Список
Период
Сортировка
От Terence Leung
Тема How to make silently truncate for char type
Дата
Msg-id 20021208120154.10496.qmail@web40705.mail.yahoo.com
обсуждение исходный текст
Ответы Re: How to make silently truncate for char type
Re: How to make silently truncate for char type
Список pgsql-general
I upgraded postgresql 7.1 to 7.2 and found that many
sql cannot execute because version 7.2 does not
silently truncate the string for char(n) type during
insert a new row.
e.g. insert t (field1) value ('abcdef');
     where field1 is char(5) but I insert the string
has 6 characters.

How can I solve the problem except downgrade the
Postgresql?

Looking forward to your reply!!!

=====
Yours sincerely,
    Leung Chun Man, Terence

    Mobile: (852) 9273 9176
    Homepage:  http://tcmleung.uhome.net ,
    http://www.dynamicdrive.com/dynamicindex4/filter/index.htm

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

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