Home
last modified time | relevance | path

Searched refs:datetmp (Results 1 – 25 of 95) sorted by relevance

1234

/dports/databases/postgresql96-server/postgresql-9.6.24/contrib/btree_gist/sql/
H A Ddate.sql3 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 Ddate.sql3 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 Ddate.sql3 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 Ddate.sql3 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 Ddate.sql3 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 Ddate.sql3 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 Ddate.sql3 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 Ddate.sql3 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 Ddate.sql3 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 Ddate.sql3 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 Ddate.sql3 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 Ddate.sql3 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 Ddate.sql3 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 Ddate.sql3 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 Ddate.sql3 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 Ddate.sql3 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 Ddate.sql3 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 Ddate.sql3 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 Ddate.sql3 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 Ddate.sql3 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 Ddate.sql3 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 Ddate.sql3 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 Ddate.sql3 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 Ddate.sql3 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 Ddate.sql3 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 …]

1234