Jean-Christian Imbeault wrote:
> How does one add a "NOT NULL" constraint to a new column?
> JC=# alter table credit_card_names alter column number_length set
> default not null;
> ERROR: Column "number_length" is of type smallint but default
ALTER TABLE [ ONLY ] table [ * ]
ALTER [ COLUMN ] column { SET | DROP } NOT NULL
i.e. alter table credit_card_names alter column number_length set not null;
--
Peter Gibbs
EmKel Systems