5
CREATE TABLE money_data (m money);
7
INSERT INTO money_data VALUES ('123');
8
SELECT * FROM money_data;
9
SELECT m + '123' FROM money_data;
10
SELECT m + '123.45' FROM money_data;
11
SELECT m - '123.45' FROM money_data;
12
SELECT m * 2 FROM money_data;
13
SELECT m / 2 FROM money_data;
16
SELECT m = '$123.00' FROM money_data;
17
SELECT m != '$124.00' FROM money_data;
18
SELECT m <= '$123.00' FROM money_data;
19
SELECT m >= '$123.00' FROM money_data;
20
SELECT m < '$124.00' FROM money_data;
21
SELECT m > '$122.00' FROM money_data;
24
SELECT m = '$123.01' FROM money_data;
25
SELECT m != '$123.00' FROM money_data;
26
SELECT m <= '$122.99' FROM money_data;
27
SELECT m >= '$123.01' FROM money_data;
28
SELECT m > '$124.00' FROM money_data;
29
SELECT m < '$122.00' FROM money_data;
31
SELECT cashlarger(m, '$124.00') FROM money_data;
32
SELECT cashsmaller(m, '$124.00') FROM money_data;
33
SELECT cash_words(m) FROM money_data;
34
SELECT cash_words(m + '1.23') FROM money_data;
36
DELETE FROM money_data;
37
INSERT INTO money_data VALUES ('$123.45');
38
SELECT * FROM money_data;
40
DELETE FROM money_data;
41
INSERT INTO money_data VALUES ('$123.451');
42
SELECT * FROM money_data;
44
DELETE FROM money_data;
45
INSERT INTO money_data VALUES ('$123.454');
46
SELECT * FROM money_data;
48
DELETE FROM money_data;
49
INSERT INTO money_data VALUES ('$123.455');
50
SELECT * FROM money_data;
52
DELETE FROM money_data;
53
INSERT INTO money_data VALUES ('$123.456');
54
SELECT * FROM money_data;
56
DELETE FROM money_data;
57
INSERT INTO money_data VALUES ('$123.459');
58
SELECT * FROM money_data;
60
-- Cast int4/int8 to money
61
SELECT 1234567890::money;
62
SELECT 12345678901234567::money;
63
SELECT 123456789012345678::money;
64
SELECT 9223372036854775807::money;
65
SELECT (-12345)::money;
66
SELECT (-1234567890)::money;
67
SELECT (-12345678901234567)::money;
68
SELECT (-123456789012345678)::money;
69
SELECT (-9223372036854775808)::money;
70
SELECT 1234567890::int4::money;
71
SELECT 12345678901234567::int8::money;
72
SELECT (-1234567890)::int4::money;
73
SELECT (-12345678901234567)::int8::money;