On Wed, Dec 24, 2008 at 6:12 PM, Erik Jones <ejones@xxxxxxxxxxxxxx> wrote: > Yes, and columns have default values, too, which are not tied to their > datatype's default value (if it even has one). ALTER TABLE initializes rows > to have the new *column's* default. A column of some domain type could > easily have some default other than the domain's default and, in fact, if > you don't specify a default for the column then it's default is NULL. the whole thing about domains, is that you specify type and default, and even check constraint. And I did specify default - hence I would expect it to be set to that value!! -- GJ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
