Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: BUG #1582: boolean DEFAULT TRUE results in FALSE for NULL values
Date
Msg-id 13008.1113163655@sss.pgh.pa.us
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 
"Eric McGough" <emcgough@yahoo.com> writes:
> -- This table and COPY command should result in all
> -- three columns defaulting to TRUE based on NULL
> -- inputs, but they all result in FALSE. Not sure why?

No, it's filling with NULL, which is what the input specifies.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1577: round(dp) function does not round to nearest integer properly
Next
From: Tom Lane
Date:
Subject: Re: BUG #1592: "with hold" cursor problem