by aarni@[EMAIL PROTECTED]
(Aarni =?iso-8859-1?q?Ruuhim=E4ki?=)
Apr 8, 2008 at 01:06 PM
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=3D# ALTER TABLE bar ADD a_boolean boolean;
ALTER TABLE
testing=3D# INSERT INTO bar (a_boolean) VALUES ('1');
INSERT 9459039 1
--=20
Aarni Ruuhim=E4ki
---
Burglars usually come in through your windows.
---
--=20
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
