public inbox for [email protected]  

help / color / mirror / Atom feed

From: Michael Fuhr <[email protected]>
To: [email protected]
Subject: Adding a Column: default values now allowed
Date: Sun, 9 Jan 2005 00:41:56 -0700
Message-ID: <[email protected]> (raw)

PostgreSQL 8.0.0rc4

5.6.1 "Adding a Column" says:

  Also, you cannot define a default value on a new column.  According
  to the SQL standard, this would have to fill the new columns in the
  existing rows with the default value, which is not implemented yet.

Adding a column with a default appears to be implemented now:

CREATE TABLE foo (label text);
INSERT INTO foo VALUES ('item 1');
INSERT INTO foo VALUES ('item 2');
INSERT INTO foo VALUES ('item 3');
ALTER TABLE foo ADD COLUMN value integer DEFAULT 123;
SELECT * FROM foo;
 label  | value 
--------+-------
 item 1 |   123
 item 2 |   123
 item 3 |   123
(3 rows)

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/

view thread (2+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Adding a Column: default values now allowed
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox