Re: Fixed length data types issue

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: Fixed length data types issue
Дата
Msg-id 871wqhv1j9.fsf@enterprisedb.com
обсуждение исходный текст
Ответ на Re: Fixed length data types issue  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Fixed length data types issue
Список pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:

> Gregory Stark wrote:
>> 
>> Well "char" doesn't have quite the same semantics as CHAR(1). If that's the
>> consensus though then I can work on either fixing "char" semantics to match
>> CHAR(1) or adding a separate type instead.
>
> What semantics?  

The main bit that comes to mind is 32::CHAR(1) give you '3' but 32::"char"
gives you ' '.

Really it makes more sense if you think of "char" is a 1 byte integer type
with some extra text casts and operators to make C programmers happy, not a 1
byte character type.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com


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

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: Optimizer improvements: to do or not to do?
Следующее
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: -HEAD planner issue wrt hash_joins on dbt3 ?