re : default value not working?

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