Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #1582: boolean DEFAULT TRUE results in FALSE for NULL values - Mailing list pgsql-bugs

From Eric McGough
Subject Re: BUG #1582: boolean DEFAULT TRUE results in FALSE for NULL values
Date
Msg-id 20050411165011.64398.qmail@web31508.mail.mud.yahoo.com
Whole thread Raw
In response to BUG #1582: boolean DEFAULT TRUE results in FALSE for NULL values  ("Eric McGough" <emcgough@yahoo.com>)
List pgsql-bugs
Tree view 
I made a mistake.

Postgres does put a NULL in the field (albiet I would still like to see
postgres/COPY change the NULL to TRUE if DEFAULT is set to true), it
appears pgAdmin III version 1.2.0 is the one displaying a boolean NULL
as FALSE (as opposed to NULL).

Sorry for not testing a little bit more before posting.

Thanks to all of you who responded.




__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

pgsql-bugs by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: BUG #1581: Problem with capitalised DB names...
Next
From: "Marcus v. Scotti"
Date:
Subject: Re: BUG #1581: Problem with capitalised DB names...