money.sql

/*
 * ------------------------------------
 * NOTE: This test behaves differenly
 * ------------------------------------
 *
 * money.out - test output for 64-bit systems and
 * money_1.out - test output for 32-bit systems.
 *
*/


set enable_seqscan=off;

CREATETABLEtest_money (
 i money
);

INSERT INTO test_money VALUES ('-2'),('-1'),('0'),('1'),('2'),('3');

CREATEINDEXidx_moneyON test_money USING rum (i);

SELECT*FROM test_money WHERE i<'1'::moneyORDER BY i;
SELECT*FROM test_money WHERE i<='1'::moneyORDER BY i;
SELECT*FROM test_money WHERE i='1'::moneyORDER BY i;
SELECT*FROM test_money WHERE i>='1'::moneyORDER BY i;
SELECT*FROM test_money WHERE i>'1'::moneyORDER BY i;

EXPLAIN (costs off)
SELECT*, i <=>0::moneyFROM test_money ORDER BY i <=>0::money;
SELECT*, i <=>0::moneyFROM test_money ORDER BY i <=>0::money;

EXPLAIN (costs off)
SELECT*, i <=>1::moneyFROM test_money WHERE i<1::moneyORDER BY i <=>1::money;
SELECT*, i <=>1::moneyFROM test_money WHERE i<1::moneyORDER BY i <=>1::money;