3
CREATE TABLE moneytmp (a money) WITH OIDS;
5
\copy moneytmp from 'data/cash.data'
9
SELECT count(*) FROM moneytmp WHERE a < '22649.64';
11
SELECT count(*) FROM moneytmp WHERE a <= '22649.64';
13
SELECT count(*) FROM moneytmp WHERE a = '22649.64';
15
SELECT count(*) FROM moneytmp WHERE a >= '22649.64';
17
SELECT count(*) FROM moneytmp WHERE a > '22649.64';
19
SELECT a, a <-> '21472.79' FROM moneytmp ORDER BY a <-> '21472.79' LIMIT 3;
21
CREATE INDEX moneyidx ON moneytmp USING gist ( a );
23
SET enable_seqscan=off;
25
SELECT count(*) FROM moneytmp WHERE a < '22649.64'::money;
27
SELECT count(*) FROM moneytmp WHERE a <= '22649.64'::money;
29
SELECT count(*) FROM moneytmp WHERE a = '22649.64'::money;
31
SELECT count(*) FROM moneytmp WHERE a >= '22649.64'::money;
33
SELECT count(*) FROM moneytmp WHERE a > '22649.64'::money;
36
SELECT a, a <-> '21472.79' FROM moneytmp ORDER BY a <-> '21472.79' LIMIT 3;
37
SELECT a, a <-> '21472.79' FROM moneytmp ORDER BY a <-> '21472.79' LIMIT 3;