Em 24/03/2017 04:18, Dmitry Yemanov escreveu: > > Also, lets consider this: > > SQL> create table t (col1 int); > SQL> insert into t values (1); > SQL> commit; > SQL> alter table t add col2 int default 123 not null; > SQL> select * from t; > > COL1 COL2 > ============ ============ > 1 123 > > SQL> alter table t alter col2 drop default; > SQL> select * from t; > > COL1 COL2 > ============ ============ > 1 123 >
Also, same behaviour as PostgreSQL. Adriano ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel