Re: boolean as 0 and 1 - Mailing list pgsql-novice

On Tue, Apr 8, 2008 at 7:54 PM, A B <gentosaker@gmail.com> wrote:

Hi,
Is there a way to make postgresql to automatically convert integer
values to boolean?

Consider

create table x (a boolean);
insert into x (a) values (1);

the inser fails :-(
Is there a way to make it work without altering the insert command?

 

Creating a custom cast might help you there....
 
--
Shoaib Mir
Fujitsu Australia Software Technology
shoaibm@fast.fujitsu.com.au