Re: Boolean - Mailing list pgsql-novice

From Tom Lane
Subject Re: Boolean
Date
Msg-id 7760.1109362367@sss.pgh.pa.us
Whole thread Raw
In response to Boolean  (<operationsengineer1@yahoo.com>)
List pgsql-novice
<operationsengineer1@yahoo.com> writes:
> i have a question about booleans.  i heard that a
> boolean takes more processing power than setting an
> integer as 1 or 0 and coding around those values.

Whoever told you that is completely clueless.

> also, i understand that db portablility is somewhat
> compromised when one uses pg's boolean data type.

It is true that there are still DBs that don't have the SQL standard
boolean type.  IIRC that was added to the standard in SQL99.  I think
this is likely to be the least of your portability concerns, however.

            regards, tom lane

pgsql-novice by date:

Previous
From:
Date:
Subject: Boolean
Next
From:
Date:
Subject: pgadmin3 column edit question