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: [EMAIL PROTECTED] #
> # 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
[EMAIL PROTECTED] | [EMAIL PROTECTED]
www.pgsql.com | www.hub.org
1-902-542-0713 | 1-902-542-3657
-----------------------------------------------------
Fascimile : 1 902 542 5386
IRC Nick : bignose