/dports/databases/postgresql96-server/postgresql-9.6.24/contrib/btree_gist/sql/ |
H A D | date.sql | 3 CREATE TABLE datetmp (a date); table 5 \copy datetmp from 'data/date.data' 9 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'; 11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'; 13 SELECT count(*) FROM datetmp WHERE a = '2001-02-13'; 15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'; 17 SELECT count(*) FROM datetmp WHERE a > '2001-02-13'; 21 CREATE INDEX dateidx ON datetmp USING gist ( a ); 25 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date; 27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date; [all …]
|
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/contrib/btree_gist/sql/ |
H A D | date.sql | 3 CREATE TABLE datetmp (a date); table 5 \copy datetmp from 'data/date.data' 9 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'; 11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'; 13 SELECT count(*) FROM datetmp WHERE a = '2001-02-13'; 15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'; 17 SELECT count(*) FROM datetmp WHERE a > '2001-02-13'; 21 CREATE INDEX dateidx ON datetmp USING gist ( a ); 25 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date; 27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date; [all …]
|
/dports/databases/postgresql96-plpython/postgresql-9.6.24/contrib/btree_gist/sql/ |
H A D | date.sql | 3 CREATE TABLE datetmp (a date); table 5 \copy datetmp from 'data/date.data' 9 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'; 11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'; 13 SELECT count(*) FROM datetmp WHERE a = '2001-02-13'; 15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'; 17 SELECT count(*) FROM datetmp WHERE a > '2001-02-13'; 21 CREATE INDEX dateidx ON datetmp USING gist ( a ); 25 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date; 27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date; [all …]
|
/dports/databases/postgresql10-plpython/postgresql-10.19/contrib/btree_gist/sql/ |
H A D | date.sql | 3 CREATE TABLE datetmp (a date); table 5 \copy datetmp from 'data/date.data' 9 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'; 11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'; 13 SELECT count(*) FROM datetmp WHERE a = '2001-02-13'; 15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'; 17 SELECT count(*) FROM datetmp WHERE a > '2001-02-13'; 21 CREATE INDEX dateidx ON datetmp USING gist ( a ); 25 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date; 27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date; [all …]
|
/dports/databases/postgresql10-server/postgresql-10.19/contrib/btree_gist/sql/ |
H A D | date.sql | 3 CREATE TABLE datetmp (a date); table 5 \copy datetmp from 'data/date.data' 9 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'; 11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'; 13 SELECT count(*) FROM datetmp WHERE a = '2001-02-13'; 15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'; 17 SELECT count(*) FROM datetmp WHERE a > '2001-02-13'; 21 CREATE INDEX dateidx ON datetmp USING gist ( a ); 25 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date; 27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date; [all …]
|
/dports/databases/postgresql10-docs/postgresql-10.19/contrib/btree_gist/sql/ |
H A D | date.sql | 3 CREATE TABLE datetmp (a date); table 5 \copy datetmp from 'data/date.data' 9 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'; 11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'; 13 SELECT count(*) FROM datetmp WHERE a = '2001-02-13'; 15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'; 17 SELECT count(*) FROM datetmp WHERE a > '2001-02-13'; 21 CREATE INDEX dateidx ON datetmp USING gist ( a ); 25 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date; 27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date; [all …]
|
/dports/databases/postgresql10-client/postgresql-10.19/contrib/btree_gist/sql/ |
H A D | date.sql | 3 CREATE TABLE datetmp (a date); table 5 \copy datetmp from 'data/date.data' 9 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'; 11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'; 13 SELECT count(*) FROM datetmp WHERE a = '2001-02-13'; 15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'; 17 SELECT count(*) FROM datetmp WHERE a > '2001-02-13'; 21 CREATE INDEX dateidx ON datetmp USING gist ( a ); 25 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date; 27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date; [all …]
|
/dports/databases/postgresql10-contrib/postgresql-10.19/contrib/btree_gist/sql/ |
H A D | date.sql | 3 CREATE TABLE datetmp (a date); table 5 \copy datetmp from 'data/date.data' 9 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'; 11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'; 13 SELECT count(*) FROM datetmp WHERE a = '2001-02-13'; 15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'; 17 SELECT count(*) FROM datetmp WHERE a > '2001-02-13'; 21 CREATE INDEX dateidx ON datetmp USING gist ( a ); 25 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date; 27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date; [all …]
|
/dports/databases/postgresql10-pltcl/postgresql-10.19/contrib/btree_gist/sql/ |
H A D | date.sql | 3 CREATE TABLE datetmp (a date); table 5 \copy datetmp from 'data/date.data' 9 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'; 11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'; 13 SELECT count(*) FROM datetmp WHERE a = '2001-02-13'; 15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'; 17 SELECT count(*) FROM datetmp WHERE a > '2001-02-13'; 21 CREATE INDEX dateidx ON datetmp USING gist ( a ); 25 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date; 27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date; [all …]
|
/dports/databases/postgresql10-plperl/postgresql-10.19/contrib/btree_gist/sql/ |
H A D | date.sql | 3 CREATE TABLE datetmp (a date); table 5 \copy datetmp from 'data/date.data' 9 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'; 11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'; 13 SELECT count(*) FROM datetmp WHERE a = '2001-02-13'; 15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'; 17 SELECT count(*) FROM datetmp WHERE a > '2001-02-13'; 21 CREATE INDEX dateidx ON datetmp USING gist ( a ); 25 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date; 27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date; [all …]
|
/dports/databases/postgresql11-plperl/postgresql-11.14/contrib/btree_gist/sql/ |
H A D | date.sql | 3 CREATE TABLE datetmp (a date); table 5 \copy datetmp from 'data/date.data' 9 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'; 11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'; 13 SELECT count(*) FROM datetmp WHERE a = '2001-02-13'; 15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'; 17 SELECT count(*) FROM datetmp WHERE a > '2001-02-13'; 21 CREATE INDEX dateidx ON datetmp USING gist ( a ); 25 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date; 27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date; [all …]
|
/dports/databases/postgresql11-docs/postgresql-11.14/contrib/btree_gist/sql/ |
H A D | date.sql | 3 CREATE TABLE datetmp (a date); table 5 \copy datetmp from 'data/date.data' 9 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'; 11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'; 13 SELECT count(*) FROM datetmp WHERE a = '2001-02-13'; 15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'; 17 SELECT count(*) FROM datetmp WHERE a > '2001-02-13'; 21 CREATE INDEX dateidx ON datetmp USING gist ( a ); 25 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date; 27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date; [all …]
|
/dports/databases/postgresql11-contrib/postgresql-11.14/contrib/btree_gist/sql/ |
H A D | date.sql | 3 CREATE TABLE datetmp (a date); table 5 \copy datetmp from 'data/date.data' 9 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'; 11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'; 13 SELECT count(*) FROM datetmp WHERE a = '2001-02-13'; 15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'; 17 SELECT count(*) FROM datetmp WHERE a > '2001-02-13'; 21 CREATE INDEX dateidx ON datetmp USING gist ( a ); 25 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date; 27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date; [all …]
|
/dports/databases/postgresql11-plpython/postgresql-11.14/contrib/btree_gist/sql/ |
H A D | date.sql | 3 CREATE TABLE datetmp (a date); table 5 \copy datetmp from 'data/date.data' 9 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'; 11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'; 13 SELECT count(*) FROM datetmp WHERE a = '2001-02-13'; 15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'; 17 SELECT count(*) FROM datetmp WHERE a > '2001-02-13'; 21 CREATE INDEX dateidx ON datetmp USING gist ( a ); 25 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date; 27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date; [all …]
|
/dports/databases/postgresql11-server/postgresql-11.14/contrib/btree_gist/sql/ |
H A D | date.sql | 3 CREATE TABLE datetmp (a date); table 5 \copy datetmp from 'data/date.data' 9 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'; 11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'; 13 SELECT count(*) FROM datetmp WHERE a = '2001-02-13'; 15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'; 17 SELECT count(*) FROM datetmp WHERE a > '2001-02-13'; 21 CREATE INDEX dateidx ON datetmp USING gist ( a ); 25 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date; 27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date; [all …]
|
/dports/databases/postgresql11-pltcl/postgresql-11.14/contrib/btree_gist/sql/ |
H A D | date.sql | 3 CREATE TABLE datetmp (a date); table 5 \copy datetmp from 'data/date.data' 9 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'; 11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'; 13 SELECT count(*) FROM datetmp WHERE a = '2001-02-13'; 15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'; 17 SELECT count(*) FROM datetmp WHERE a > '2001-02-13'; 21 CREATE INDEX dateidx ON datetmp USING gist ( a ); 25 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date; 27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date; [all …]
|
/dports/databases/postgresql11-client/postgresql-11.14/contrib/btree_gist/sql/ |
H A D | date.sql | 3 CREATE TABLE datetmp (a date); table 5 \copy datetmp from 'data/date.data' 9 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'; 11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'; 13 SELECT count(*) FROM datetmp WHERE a = '2001-02-13'; 15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'; 17 SELECT count(*) FROM datetmp WHERE a > '2001-02-13'; 21 CREATE INDEX dateidx ON datetmp USING gist ( a ); 25 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date; 27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date; [all …]
|
/dports/databases/postgresql12-contrib/postgresql-12.9/contrib/btree_gist/sql/ |
H A D | date.sql | 3 CREATE TABLE datetmp (a date); 5 \copy datetmp from 'data/date.data' 9 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'; 11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'; 13 SELECT count(*) FROM datetmp WHERE a = '2001-02-13'; 15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'; 17 SELECT count(*) FROM datetmp WHERE a > '2001-02-13'; 21 CREATE INDEX dateidx ON datetmp USING gist ( a ); 25 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date; 27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date; [all …]
|
/dports/databases/postgresql12-client/postgresql-12.9/contrib/btree_gist/sql/ |
H A D | date.sql | 3 CREATE TABLE datetmp (a date); table 5 \copy datetmp from 'data/date.data' 9 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'; 11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'; 13 SELECT count(*) FROM datetmp WHERE a = '2001-02-13'; 15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'; 17 SELECT count(*) FROM datetmp WHERE a > '2001-02-13'; 21 CREATE INDEX dateidx ON datetmp USING gist ( a ); 25 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date; 27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date; [all …]
|
/dports/databases/postgresql14-server/postgresql-14.1/contrib/btree_gist/sql/ |
H A D | date.sql | 3 CREATE TABLE datetmp (a date); table 5 \copy datetmp from 'data/date.data' 9 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'; 11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'; 13 SELECT count(*) FROM datetmp WHERE a = '2001-02-13'; 15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'; 17 SELECT count(*) FROM datetmp WHERE a > '2001-02-13'; 21 CREATE INDEX dateidx ON datetmp USING gist ( a ); 25 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date; 27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date; [all …]
|
/dports/databases/postgresql96-client/postgresql-9.6.24/contrib/btree_gist/sql/ |
H A D | date.sql | 3 CREATE TABLE datetmp (a date); table 5 \copy datetmp from 'data/date.data' 9 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'; 11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'; 13 SELECT count(*) FROM datetmp WHERE a = '2001-02-13'; 15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'; 17 SELECT count(*) FROM datetmp WHERE a > '2001-02-13'; 21 CREATE INDEX dateidx ON datetmp USING gist ( a ); 25 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date; 27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date; [all …]
|
/dports/databases/postgresql14-plpython/postgresql-14.1/contrib/btree_gist/sql/ |
H A D | date.sql | 3 CREATE TABLE datetmp (a date); table 5 \copy datetmp from 'data/date.data' 9 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'; 11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'; 13 SELECT count(*) FROM datetmp WHERE a = '2001-02-13'; 15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'; 17 SELECT count(*) FROM datetmp WHERE a > '2001-02-13'; 21 CREATE INDEX dateidx ON datetmp USING gist ( a ); 25 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date; 27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date; [all …]
|
/dports/databases/postgresql14-plperl/postgresql-14.1/contrib/btree_gist/sql/ |
H A D | date.sql | 3 CREATE TABLE datetmp (a date); table 5 \copy datetmp from 'data/date.data' 9 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'; 11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'; 13 SELECT count(*) FROM datetmp WHERE a = '2001-02-13'; 15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'; 17 SELECT count(*) FROM datetmp WHERE a > '2001-02-13'; 21 CREATE INDEX dateidx ON datetmp USING gist ( a ); 25 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date; 27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date; [all …]
|
/dports/databases/postgresql14-pltcl/postgresql-14.1/contrib/btree_gist/sql/ |
H A D | date.sql | 3 CREATE TABLE datetmp (a date); table 5 \copy datetmp from 'data/date.data' 9 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'; 11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'; 13 SELECT count(*) FROM datetmp WHERE a = '2001-02-13'; 15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'; 17 SELECT count(*) FROM datetmp WHERE a > '2001-02-13'; 21 CREATE INDEX dateidx ON datetmp USING gist ( a ); 25 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date; 27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date; [all …]
|
/dports/databases/postgresql13-pltcl/postgresql-13.5/contrib/btree_gist/sql/ |
H A D | date.sql | 3 CREATE TABLE datetmp (a date); 5 \copy datetmp from 'data/date.data' 9 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'; 11 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'; 13 SELECT count(*) FROM datetmp WHERE a = '2001-02-13'; 15 SELECT count(*) FROM datetmp WHERE a >= '2001-02-13'; 17 SELECT count(*) FROM datetmp WHERE a > '2001-02-13'; 21 CREATE INDEX dateidx ON datetmp USING gist ( a ); 25 SELECT count(*) FROM datetmp WHERE a < '2001-02-13'::date; 27 SELECT count(*) FROM datetmp WHERE a <= '2001-02-13'::date; [all …]
|