Why isn't the following allowed ?

create table test (
number integer default gen_id (gen_test, 1),
age integer check (age > 20),
name varchar (20))

Regards

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz