Re: boolean as 0 and 1

On Tue, Apr 8, 2008 at 7:58 PM, Shoaib Mir <shoaibmir(at)gmail(dot)com> wrote:

> On Tue, Apr 8, 2008 at 7:54 PM, A B <gentosaker(at)gmail(dot)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?
> >
>
>
>

Try using this:

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

It worked for me in 8.3

--
Shoaib Mir
Fujitsu Australia Software Technology
shoaibm(at)fast(dot)fujitsu(dot)com(dot)au