Re: Help with ADD COLUMN

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
Cc: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Help with ADD COLUMN
Date: 2002-11-24 16:14:01
Message-ID: 1038154441.15560.48.camel@huli
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, 2002-11-24 at 08:34, Philip Warner wrote:
> At 03:48 PM 23/11/2002 -0800, Christopher Kings-Lynne wrote:
> >I assume that's the correct behaviour? If they specify a default, the
> >column should be auto-filled with that default, right?
>
> Good question. We might want some input from other DBs; Dec RDB default
> existing rows to NULL irrespective of the 'DEFAULT' clause.

Also, how would I express a new column with default for which I _want_
that column in old records to be NULL ?

----------------
Hannu

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-11-24 17:35:39 Re: Help with ADD COLUMN
Previous Message Rod Taylor 2002-11-24 14:24:45 Re: Help with ADD COLUMN