# add boolean column with defaultValueNumeric

**URL:** <https://forum.liquibase.org/t/add-boolean-column-with-defaultvaluenumeric/1446>\
**Category:** Liquibase Development\
**Created:** [October 25, 2010, 12:12pm UTC](https://forum.liquibase.org/t/add-boolean-column-with-defaultvaluenumeric/1446 "2010-10-25T12:12:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![chris\_wesdorp](https://avatars.discourse-cdn.com/v4/letter/c/41988e/32.png) [@chris\_wesdorp](https://forum.liquibase.org/u/chris_wesdorp)\
**Post date:** [October 25, 2010, 12:12pm UTC](https://forum.liquibase.org/t/add-boolean-column-with-defaultvaluenumeric/1446/1 "2010-10-25T12:12:00Z")

</div>

Hello,

although this is not very logical I run into the following problem. In Liquibase 1.9.x it is possible to specify a new boolean column with a default numeric value. With the current RC of the coming 2.0 this is not possible anymore. Because I have this in some older change logs here is a patch to BooleanType which also parses numeric values. 1 becomes true, everything else false. If you agree to this, can you include it?

Regards,  
Chris

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [October 25, 2010, 12:12pm UTC](https://forum.liquibase.org/t/add-boolean-column-with-defaultvaluenumeric/1446/2 "2010-10-25T12:12:00Z")

</div>

Yes, it does look like a good idea.&nbsp; I generally like to have it do what people would expect over being exactly syntatically correct.&nbsp; I committed your patch, thanks!

Nathan

---

<div class="post-metadata">

**Author:** ![chris\_wesdorp](https://avatars.discourse-cdn.com/v4/letter/c/41988e/32.png) [@chris\_wesdorp](https://forum.liquibase.org/u/chris_wesdorp)\
**Post date:** [October 25, 2010, 12:12pm UTC](https://forum.liquibase.org/t/add-boolean-column-with-defaultvaluenumeric/1446/3 "2010-10-25T12:12:00Z")

</div>

Thanks (also for the other one).
