Обсуждение: boolean as 0 and 1
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?
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
--
Shoaib Mir
Fujitsu Australia Software Technology
shoaibm@fast.fujitsu.com.au
On Tue, Apr 8, 2008 at 7:58 PM, Shoaib Mir <shoaibmir@gmail.com> wrote:
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?
Try using this:
create table x (a boolean);
insert into x (a) values (1::boolean);
insert into x (a) values (1::boolean);
It worked for me in 8.3
--
Shoaib Mir
Fujitsu Australia Software Technology
On Tuesday 08 April 2008 12:54, A B 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? Hi, testing=# ALTER TABLE bar ADD a_boolean boolean; ALTER TABLE testing=# INSERT INTO bar (a_boolean) VALUES ('1'); INSERT 9459039 1 -- Aarni Ruuhimäki --- Burglars usually come in through your windows. ---