7.4: CHAR padding inconsistency

Поиск
Список
Период
Сортировка
От Troels Arvin
Тема 7.4: CHAR padding inconsistency
Дата
Msg-id pan.2003.11.19.02.55.07.726305@arvin.dk
обсуждение исходный текст
Ответы Re: 7.4: CHAR padding inconsistency
Список pgsql-bugs
Hello,

I read about the padding-of-CHAR-values changes in the release notes for
7.4.

Making PostgreSQL less standard compliant is sad; I also disagree
with the statement that trimming of trailing white-space is what people
expect.

What's worse, and this may be classified as an error:

create table chartest(col char(10) not null);
insert into chartest values ('AAA');

select character_length(col) from chartest;
 character_length
------------------
               10

select character_length(col || 'hey') from chartest;
 character_length
------------------
                6

SELECT CHARACTER_LENGTH(col) <
  CHARACTER_LENGTH(col||'hey') from chartest;
 ?column?
----------
 f

The last two results are horrifying, in my opinion, especially when you
consider them in concert: Concatenating a value with another value
decreases its length...

--
Greetings from Troels Arvin, Copenhagen, Denmark

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

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: Build problems for PostgreSQL v7.4 on FreeBSD v4.1
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: 7.4: CHAR padding inconsistency