Re: select

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