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 по дате отправления: