← 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/timestamp.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/timestamp.out
 
1
-- timestamp check
 
2
CREATE TABLE timestamptmp (a timestamp);
 
3
\copy timestamptmp from 'data/timestamp.data'
 
4
SET enable_seqscan=on;
 
5
SELECT count(*) FROM timestamptmp WHERE a <  '2004-10-26 08:55:08';
 
6
 count 
 
7
-------
 
8
   278
 
9
(1 row)
 
10
 
 
11
SELECT count(*) FROM timestamptmp WHERE a <= '2004-10-26 08:55:08';
 
12
 count 
 
13
-------
 
14
   279
 
15
(1 row)
 
16
 
 
17
SELECT count(*) FROM timestamptmp WHERE a  = '2004-10-26 08:55:08';
 
18
 count 
 
19
-------
 
20
     1
 
21
(1 row)
 
22
 
 
23
SELECT count(*) FROM timestamptmp WHERE a >= '2004-10-26 08:55:08';
 
24
 count 
 
25
-------
 
26
   290
 
27
(1 row)
 
28
 
 
29
SELECT count(*) FROM timestamptmp WHERE a >  '2004-10-26 08:55:08';
 
30
 count 
 
31
-------
 
32
   289
 
33
(1 row)
 
34
 
 
35
CREATE INDEX timestampidx ON timestamptmp USING gist ( a );
 
36
SET enable_seqscan=off;
 
37
SELECT count(*) FROM timestamptmp WHERE a <  '2004-10-26 08:55:08'::timestamp;
 
38
 count 
 
39
-------
 
40
   278
 
41
(1 row)
 
42
 
 
43
SELECT count(*) FROM timestamptmp WHERE a <= '2004-10-26 08:55:08'::timestamp;
 
44
 count 
 
45
-------
 
46
   279
 
47
(1 row)
 
48
 
 
49
SELECT count(*) FROM timestamptmp WHERE a  = '2004-10-26 08:55:08'::timestamp;
 
50
 count 
 
51
-------
 
52
     1
 
53
(1 row)
 
54
 
 
55
SELECT count(*) FROM timestamptmp WHERE a >= '2004-10-26 08:55:08'::timestamp;
 
56
 count 
 
57
-------
 
58
   290
 
59
(1 row)
 
60
 
 
61
SELECT count(*) FROM timestamptmp WHERE a >  '2004-10-26 08:55:08'::timestamp;
 
62
 count 
 
63
-------
 
64
   289
 
65
(1 row)
 
66