bignose=# create table test (
bignose(# val1 int4,
bignose(# val2 boolean);
CREATE
bignose=#
bignose=# insert into test (val1) values (56);
INSERT 322762 1
bignose=#
bignose=# select * from test;val1 | val2
------+------ 56 |
(1 row)
ta da :)
On Sat, 23 Sep 2000, Indraneel Majumdar wrote:
> Hi,
>
> AFAIK, you can't enter a null value in a bool field, it has to be 1 or 0.
>
> \Indraneel
>
> On Sat, 23 Sep 2000, Jeff MacDonald wrote:
>
> > how would i select all rows where a boolean value is neither
> > t nor f.. ?
> >
> > ie if someone inserted without setting the boolean tag.
> >
> > Jeff MacDonald,
> >
>
> /************************************************************************.
> # Indraneel Majumdar � E-mail: indraneel@123india.com #
> # Bioinformatics Unit (EMBNET node), � URL: http://scorpius.iwarp.com #
> # Centre for DNA Fingerprinting and Diagnostics, #
> # Hyderabad, India - 500076 #
> `************************************************************************/
>
Jeff MacDonald,
-----------------------------------------------------
PostgreSQL Inc | Hub.Org Networking Services
jeff@pgsql.com | jeff@hub.org
www.pgsql.com | www.hub.org
1-902-542-0713 | 1-902-542-3657
-----------------------------------------------------
Fascimile : 1 902 542 5386
IRC Nick : bignose