Re: char(0)

Поиск
Список
Период
Сортировка
От PostgreSQL - Hans-Jürgen Schönig
Тема Re: char(0)
Дата
Msg-id 53019DA1-1161-473F-A6BF-D9907CB0B5B0@cybertec.at
обсуждение исходный текст
Ответ на char(0)  (Susanne Ebrecht <susanne@2ndQuadrant.com>)
Список pgsql-bugs
On Oct 17, 2011, at 9:31 AM, Susanne Ebrecht wrote:

> Hello,
>
> I couldn't find that somebody already mentioned it.
>
> PostgreSQL isn't supporting CHAR(0).
>
> An empty string has a length of 0.
>
> CHAR(0) can have two values: NULL and empty string.
>
> In MySQL it is very common to simulate not null boolean
> by using CHAR(0).
>
> This is a little bit annoying on migration topics.
>
> Susanne


hello ....

i would actually see it the other way round.
supporting char(0) is the bug here ...
if somebody used char(0) to simulate boolean not null ... let me not comment on that one for social reasons ;).
regards,
    hans

--
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt, Austria
Web: http://www.postgresql-support.de



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

Предыдущее
От: Susanne Ebrecht
Дата:
Сообщение: char(0)
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: char(0)