"Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx> writes: > Anton Melser wrote: >> Is there any way >> to force pg to accept 1 and 0 for boolean? > postgres=# insert into bool_test values(1::boolean); > INSERT 166968558 1 > postgres=# insert into bool_test values(0::boolean); > INSERT 166968559 1 Possibly Anton is using an old version in which there wasn't a built in int-to-bool cast? regards, tom lane