Decimal precsion? - Mailing list pgsql-sql

From Zot O'Connor
Subject Decimal precsion?
Date
Msg-id 381A1EFC.47061275@zotconsulting.com
Whole thread Raw
Responses Re: [SQL] Decimal precsion?  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: [SQL] random query
Next
From: "Zot O'Connor"
Date:
Subject: Numeric Bug?