Re: An amusing MySQL weakness--not! - Mailing list pgsql-general

From Vincent Veyron
Subject Re: An amusing MySQL weakness--not!
Date
Msg-id 1309178900.2381.81.camel@asus-1001PX.home
Whole thread Raw
In response to Re: An amusing MySQL weakness--not!  (Leif Biberg Kristensen <leif@solumslekt.org>)
List 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 by date:

Previous
From: Sim Zacks
Date:
Subject: discard on constraint violation
Next
From: Guillaume Lelarge
Date:
Subject: Re: discard on constraint violation