AW: [HACKERS] char(8) vs char8

Поиск
Список
Период
Сортировка
От Andreas Zeugswetter
Тема AW: [HACKERS] char(8) vs char8
Дата
Msg-id 01BD7F59.9CE62FB0@zeugswettera.user.lan.at
обсуждение исходный текст
Список pgsql-hackers
> This was an unexpected difference between these two types and I wonder
> if it was meant to be this way.  Previously, a char8 field with the
> string 'abc' would return 'abc' as expected.  Now, with char(8), I get
> back 'abc     ' instead.  You can see this with my PygreSQL module
> or the C interface (which my module uses, of course.)  This causes a
> lot of my programs to break.

This is the expected behavior for the char() datatype. If you have other variable
length fields in the table, you can simply use varchar() which does not blank pad
to the specified length. If you don't have other variable length fields then you
loose some performance if you switch to varchar().

> I have made a quick change to my Python module to handle this.  Should
> I clean it up or can I expect the behaviour to go back the way it was?

No, it will stay.

Andreas



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

Предыдущее
От: Michal Mosiewicz
Дата:
Сообщение: Re: [HACKERS] Sequential scan speed, mmap, disk i/o
Следующее
От: Byron Nikolaidis
Дата:
Сообщение: Re: [HACKERS] char(8) vs char8