BUG #1582: boolean DEFAULT TRUE results in FALSE for NULL values

From: "Eric McGough" <emcgough(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1582: boolean DEFAULT TRUE results in FALSE for NULL values
Date: 2005-04-05 20:11:12
Message-ID: 20050405201112.DC108F0FEC@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1582
Logged by: Eric McGough
Email address: emcgough(at)yahoo(dot)com
PostgreSQL version: 8.0.1
Operating system: Solaris 8
Description: boolean DEFAULT TRUE results in FALSE for NULL values
Details:

-- 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?

CREATE TABLE my_table (
field1 boolean DEFAULT TRUE,
field2 boolean DEFAULT TRUE,
field3 boolean DEFAULT TRUE
);

COPY my_table FROM STDIN WITH DELIMITER AS '|';
\N|\N|\N
\.

using http://www.sunfreeware.com complied postgres
postgresql-8.0.1-sol8-sparc-local

on SunOS cawncknms 5.8 Generic_117350-11 sun4u sparc SUNW,Ultra-Enterprise

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Grillet 2005-04-05 20:13:07 BUG #1583: Locale problem
Previous Message falcon 2005-04-05 18:38:37 Repeat RULE ON INSERT and DEFAULT nextval('...')