BUG #1582: boolean DEFAULT TRUE results in FALSE for NULL values
| От | Eric McGough |
|---|---|
| Тема | BUG #1582: boolean DEFAULT TRUE results in FALSE for NULL values |
| Дата | |
| Msg-id | 20050405201112.DC108F0FEC@svr2.postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #1582: boolean DEFAULT TRUE results in FALSE for NULL values
Re: BUG #1582: boolean DEFAULT TRUE results in FALSE for NULL values |
| Список | pgsql-bugs |
The following bug has been logged online:
Bug reference: 1582
Logged by: Eric McGough
Email address: emcgough@yahoo.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
В списке pgsql-bugs по дате отправления: