On Oct 10, 2009, at 3:33 AM, Jasen Betts wrote:
CREATE DOMAN sales_tax_rate AS DECIMAL CHECK (VALUE >= 0 AND VALUE <=1);why the latter check ( VALUE <=1 )?
Since this version has no scale on the DECIMAL, the second check keeps it from being larger than 1.0, since it's presumably a percentage from 0% to 99%.
-- -- Christophe Pettus [email protected] -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
