Search Postgresql Archives

Re: An amusing MySQL weakness--not!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



hello

2011/6/26 Vincent Veyron <vv.lists@xxxxxxxxxx>:
> Le dimanche 26 juin 2011 à 00:05 -0700, Darren Duncan a écrit :
>> Michael Nolan wrote:
>
>> Having real BOOLEAN is just one of the reasons I like Postgres the most.
>>
>
> Would you mind giving an example of where a boolean field would be a win
> over an integer one?

everywhere, where you require readability. For me a FALSE is more
readable than 1 <> 0 or TRUE instead 1 = 1

Regards

Pavel Stehule

>
> I'm asking this because I frequently wonder what is best for my use; I
> normally query postgres via Perl modules, which don't care about boolean
> (the driver converts t/f to 0/1), but I like to tune my fields properly.
>

sure, it depends on fact if outer environment knows or doesn't know a
boolean datatype.



>
> --
> Vincent Veyron
> http://marica.fr/
> Logiciel de gestion des sinistres et des contentieux pour le service juridique
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux