Re: An amusing MySQL weakness--not!

Поиск
Список
Период
Сортировка
От Vincent Veyron
Тема Re: An amusing MySQL weakness--not!
Дата
Msg-id 1309178900.2381.81.camel@asus-1001PX.home
обсуждение исходный текст
Ответ на Re: An amusing MySQL weakness--not!  (Leif Biberg Kristensen <leif@solumslekt.org>)
Список pgsql-general
Le lundi 27 juin 2011 à 12:11 +0200, Leif Biberg Kristensen a écrit :
> PHP has its own Boolean values TRUE/FALSE, but reads Postgresql
> Booleans as
> 't'/'f'. You always have to rely on kludgy konstructs like
>
> if ($pg_bool == 't') then
>     $my_bool = TRUE;
> elseif ($pg_bool == 'f') then
>     $my_bool = FALSE;
> else
>     $my_bool = NULL;
>
> It's of course much easier to use integer values, but it sucks not to
> use a
> bool when you want a variable that can't be anything but TRUE, FALSE
> or NULL.
>

Same thing with Perl.

But I am starting to think that the benefits of data integrity
mentionned by Stephen are worth the extra effort : you save on
validation needs anyway, which is probably another couple of lines, if
not more, and less reliable.

--
Vincent Veyron
http://marica.fr/
Logiciel de gestion des sinistres et des contentieux pour le service juridique


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

Предыдущее
От: Sim Zacks
Дата:
Сообщение: discard on constraint violation
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: discard on constraint violation