To have boolean type in Postgres for PHP

Question

I can't believe that the following statement seems to be still true

So, I switched to integers and 0 or 1 works fine, but it is
stupid, that the database system has boolean variables of a smaller
size, but I should use integers for boolean values!

How do you use boolean datatype with Postgres / PHP?

In other words,

Is the only way to use 1 for true and 0 for false in getting the kind of the boolean datatype?

karim79 · Accepted Answer · 2009-08-22 01:33:21Z

0

Using 1 and 0 is a very sensible and portable way to represent boolean values. Any difference in size between and int and a native boolean type is really going to make little or no difference to your application's performance, or the KB size of your database.

answered Aug 22, 2009 at 1:33

karim79

343k67 gold badges420 silver badges409 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Léo Léopold Hertz 준영 Over a year ago

Your answer suggests me that I need to change every datatype BOOLEAN in my SQL queries to INTEGER. It is strange that the BOOLEAN is made string by postgres after running the queries.

karim79 Over a year ago

I wasn't suggesting that you change anything. Maybe out of habit or personal preference, I tend to use 0 & 1s to represent booleans. If that is already working for you, don't spend too much time thinking about it.

Léo Léopold Hertz 준영 Over a year ago

Figures are easy. Let's use them :)

txwikinger Over a year ago

Mysql actually uses 0 and 1 in a tinyint(1) when you define a boolean datatype.

Collectives™ on Stack Overflow

To have boolean type in Postgres for PHP

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related