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

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Eric McGough <emcgough(at)yahoo(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1582: boolean DEFAULT TRUE results in FALSE for NULL values
Date: 2005-04-11 02:24:29
Message-ID: 20050411022429.GA23646@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, Apr 05, 2005 at 21:11:12 +0100,
Eric McGough <emcgough(at)yahoo(dot)com> wrote:
>
> COPY my_table FROM STDIN WITH DELIMITER AS '|';
> \N|\N|\N
> \.

COPY doesn't provide a way to use default values for just some rows.
You can get the default for a column by leaving it out of an explicit
column list. But that will apply for all rows.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-04-11 05:51:57 Re: BUG #1584: undefined symbol _tas
Previous Message Benjamin Reed 2005-04-11 02:03:01 Re: BUG #1584: undefined symbol _tas