numeric_big.sql

PostgreSQL 8.1.4的源码 适用于Linux下的开源数据库系统

-- ******************************
-- * Test suite for the Postgres NUMERIC data type
-- ******************************

-- Must drop tables created by short numeric test.
DROP TABLE num_data;
DROP TABLE num_exp_add;
DROP TABLE num_exp_sub;
DROP TABLE num_exp_div;
DROP TABLE num_exp_mul;
DROP TABLE num_exp_sqrt;
DROP TABLE num_exp_ln;
DROP TABLE num_exp_log10;
DROP TABLE num_exp_power_10_ln;
DROP TABLE num_result;

CREATE TABLE num_data (id int4, val numeric(1000,800));
CREATE TABLE num_exp_add (id1 int4, id2 int4, expected numeric(1000,800));
CREATE TABLE num_exp_sub (id1 int4, id2 int4, expected numeric(1000,800));
CREATE TABLE num_exp_div (id1 int4, id2 int4, expected numeric(1000,800));
CREATE TABLE num_exp_mul (id1 int4, id2 int4, expected numeric(1000,800));
CREATE TABLE num_exp_sqrt (id int4, expected numeric(1000,800));
CREATE TABLE num_exp_ln (id int4, expected numeric(1000,800));
CREATE TABLE num_exp_log10 (id int4, expected numeric(1000,800));
CREATE TABLE num_exp_power_10_ln (id int4, expected numeric(1000,800));

CREATE TABLE num_result (id1 int4, id2 int4, result numeric(1000,800));


-- ******************************
-- * The following EXPECTED results are computed by bc(1)
-- * with a scale of 1000
-- ******************************

BEGIN TRANSACTION;