Postgresql boolean

Question

Postgresql stores boolean value TRUE or FALSE, while I am passing 1 or 0. And I want to store as 1 or 0 instead of TRUE or FALSE.

Can anyone help me on this please?

Could you please elaborate why you need this? What's wrong with TRUE and FALSE? Also, SELECT TRUE::integer, FALSE::integer; — András Váczi, Aug 11 '16 at 12:47
nothing issue with TRUE and FALSE but I want to stick to save 0 and 1 rather than TRUE and FALSE. — kunal kumar, Aug 11 '16 at 12:52
Why would you want to do that? Store your data in a numeric type if you really want but this looks like a presentation issue rather than a data issue. — Tom V, Aug 11 '16 at 17:51

score 1 · Accepted Answer · answered Aug 11 '16 at 12:51

1

You might have made data type as Boolean

If you want to save as 1 and 0 only, then you should make data type as Small Int

Then you will be able to save as 1 or 0 and retrieve the same.

answered Aug 11 '16 at 12:51

Somnath Muluk

1 Answers1