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(at)123india(dot)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(at)pgsql(dot)com | jeff(at)hub(dot)org
www.pgsql.com | www.hub.org
1-902-542-0713 | 1-902-542-3657
-----------------------------------------------------
Fascimile : 1 902 542 5386
IRC Nick : bignose