2
CREATE TABLE moneytmp (a money) WITH OIDS;
3
\copy moneytmp from 'data/cash.data'
5
SELECT count(*) FROM moneytmp WHERE a < '22649.64';
11
SELECT count(*) FROM moneytmp WHERE a <= '22649.64';
17
SELECT count(*) FROM moneytmp WHERE a = '22649.64';
23
SELECT count(*) FROM moneytmp WHERE a >= '22649.64';
29
SELECT count(*) FROM moneytmp WHERE a > '22649.64';
35
SELECT a, a <-> '21472.79' FROM moneytmp ORDER BY a <-> '21472.79' LIMIT 3;
37
------------+----------
43
CREATE INDEX moneyidx ON moneytmp USING gist ( a );
44
SET enable_seqscan=off;
45
SELECT count(*) FROM moneytmp WHERE a < '22649.64'::money;
51
SELECT count(*) FROM moneytmp WHERE a <= '22649.64'::money;
57
SELECT count(*) FROM moneytmp WHERE a = '22649.64'::money;
63
SELECT count(*) FROM moneytmp WHERE a >= '22649.64'::money;
69
SELECT count(*) FROM moneytmp WHERE a > '22649.64'::money;
76
SELECT a, a <-> '21472.79' FROM moneytmp ORDER BY a <-> '21472.79' LIMIT 3;
78
-----------------------------------------------
80
-> Index Scan using moneyidx on moneytmp
81
Order By: (a <-> '$21,472.79'::money)
84
SELECT a, a <-> '21472.79' FROM moneytmp ORDER BY a <-> '21472.79' LIMIT 3;
86
------------+----------