Hi,
No default values works, but default values works
only if no value( no '' or null ) was getting to this rows ...
example :
create table test ( name varchar(1) default 'N',id integer)
# we insert values except in name column
insert into test(id) values(12);
select * from test
N 12
insert into test values('',13);
select * from test
13
And is the same for null value
Cheers,
PEJAC Pascal