← Back to branch summary

~ubuntu-branches/ubuntu/hardy/postgresql-8.4/hardy-backports

« back to all changes in this revision

Viewing changes to contrib/btree_gist/expected/int2.out

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2009-03-20 12:00:13 UTC
  • Revision ID: james.westby@ubuntu.com-20090320120013-hogj7egc5mjncc5g
Tags: upstream-8.4~0cvs20090328
Import upstream version 8.4~0cvs20090328

Show diffs side-by-side

added added

removed removed

Lines of Context:
contrib/btree_gist/expected/int2.out
 
1
-- int2 check
 
2
CREATE TABLE int2tmp (a int2);
 
3
\copy int2tmp from 'data/int2.data'
 
4
SET enable_seqscan=on;
 
5
SELECT count(*) FROM int2tmp WHERE a <  237;
 
6
 count 
 
7
-------
 
8
   297
 
9
(1 row)
 
10
 
 
11
SELECT count(*) FROM int2tmp WHERE a <= 237;
 
12
 count 
 
13
-------
 
14
   298
 
15
(1 row)
 
16
 
 
17
SELECT count(*) FROM int2tmp WHERE a  = 237;
 
18
 count 
 
19
-------
 
20
     1
 
21
(1 row)
 
22
 
 
23
SELECT count(*) FROM int2tmp WHERE a >= 237;
 
24
 count 
 
25
-------
 
26
   249
 
27
(1 row)
 
28
 
 
29
SELECT count(*) FROM int2tmp WHERE a >  237;
 
30
 count 
 
31
-------
 
32
   248
 
33
(1 row)
 
34
 
 
35
CREATE INDEX int2idx ON int2tmp USING gist ( a );
 
36
SET enable_seqscan=off;
 
37
SELECT count(*) FROM int2tmp WHERE a <  237::int2;
 
38
 count 
 
39
-------
 
40
   297
 
41
(1 row)
 
42
 
 
43
SELECT count(*) FROM int2tmp WHERE a <= 237::int2;
 
44
 count 
 
45
-------
 
46
   298
 
47
(1 row)
 
48
 
 
49
SELECT count(*) FROM int2tmp WHERE a  = 237::int2;
 
50
 count 
 
51
-------
 
52
     1
 
53
(1 row)
 
54
 
 
55
SELECT count(*) FROM int2tmp WHERE a >= 237::int2;
 
56
 count 
 
57
-------
 
58
   249
 
59
(1 row)
 
60
 
 
61
SELECT count(*) FROM int2tmp WHERE a >  237::int2;
 
62
 count 
 
63
-------
 
64
   248
 
65
(1 row)
 
66