Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group