Flemming Frandsen wrote : >I've seen integrity constraint violations when trying to actually >insert/update null into columns that are nullable and have a default >value other than null.
>Can it really be true that I can't declare a default value for a >nullable column? It should be no problem to insert null values into a column even if a default value for that column is defined. Of course no NOT NULL clause for that column must be defined. I made the following test : CREATE TABLE TEST (COL1 INTEGER DEFAULT 0); INSERT TEST SET COL1 = NULL; UPDATE TEST SET COL1 = DEFAULT; UPDATE TEST SET COL1 = NULL WHERE COL1 = DEFAULT; and did not find any problems. If you have an example that show an other behavior, please let me know. Thomas --- Thomas Anhaus SAPDB, SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
