create table subzone (
subzid integer,
subzsid integer DEFAULT NEXTVAL ('subzone_seq'),
subzdescr varchar,
subztaxper decimal(0,4),
subzvendid integer,
subzwhsid integer,
subztaxship integer
);
ERROR: DECIMAL precision 0 must be beween 1 and 1000
Is this documented anywhere? By the way it should be "beTween."
--
Zot O'Connor
www.ZotConsulting.com
www.WhiteKnightHackers.com