Home
last modified time | relevance | path

Searched refs:test_seg (Results 1 – 25 of 133) sorted by relevance

123456

/dports/databases/postgresql11-client/postgresql-11.14/contrib/seg/sql/
H A Dseg.sql214 CREATE TABLE test_seg (s seg); table
216 \copy test_seg from 'data/test_seg.data'
218 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
222 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
223 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
228 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
229 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
233 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
237 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
/dports/databases/postgresql11-docs/postgresql-11.14/contrib/seg/sql/
H A Dseg.sql214 CREATE TABLE test_seg (s seg); table
216 \copy test_seg from 'data/test_seg.data'
218 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
222 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
223 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
228 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
229 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
233 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
237 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
/dports/databases/postgresql11-contrib/postgresql-11.14/contrib/seg/sql/
H A Dseg.sql214 CREATE TABLE test_seg (s seg); table
216 \copy test_seg from 'data/test_seg.data'
218 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
222 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
223 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
228 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
229 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
233 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
237 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
/dports/databases/postgresql11-plperl/postgresql-11.14/contrib/seg/sql/
H A Dseg.sql214 CREATE TABLE test_seg (s seg); table
216 \copy test_seg from 'data/test_seg.data'
218 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
222 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
223 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
228 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
229 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
233 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
237 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
/dports/databases/postgresql11-plpython/postgresql-11.14/contrib/seg/sql/
H A Dseg.sql214 CREATE TABLE test_seg (s seg);
216 \copy test_seg from 'data/test_seg.data'
218 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
222 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
223 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
228 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
229 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
233 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
237 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
/dports/databases/postgresql11-server/postgresql-11.14/contrib/seg/sql/
H A Dseg.sql214 CREATE TABLE test_seg (s seg); table
216 \copy test_seg from 'data/test_seg.data'
218 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
222 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
223 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
228 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
229 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
233 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
237 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
/dports/databases/postgresql12-client/postgresql-12.9/contrib/seg/sql/
H A Dseg.sql214 CREATE TABLE test_seg (s seg); table
216 \copy test_seg from 'data/test_seg.data'
218 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
222 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
223 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
228 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
229 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
233 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
237 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
/dports/databases/postgresql11-pltcl/postgresql-11.14/contrib/seg/sql/
H A Dseg.sql214 CREATE TABLE test_seg (s seg); table
216 \copy test_seg from 'data/test_seg.data'
218 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
222 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
223 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
228 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
229 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
233 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
237 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
/dports/databases/postgresql14-pltcl/postgresql-14.1/contrib/seg/sql/
H A Dseg.sql214 CREATE TABLE test_seg (s seg); table
216 \copy test_seg from 'data/test_seg.data'
218 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
222 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
223 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
228 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
229 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
233 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
237 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
/dports/databases/postgresql14-server/postgresql-14.1/contrib/seg/sql/
H A Dseg.sql214 CREATE TABLE test_seg (s seg); table
216 \copy test_seg from 'data/test_seg.data'
218 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
222 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
223 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
228 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
229 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
233 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
237 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
/dports/databases/postgresql14-plpython/postgresql-14.1/contrib/seg/sql/
H A Dseg.sql214 CREATE TABLE test_seg (s seg); table
216 \copy test_seg from 'data/test_seg.data'
218 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
222 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
223 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
228 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
229 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
233 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
237 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
/dports/databases/postgresql14-plperl/postgresql-14.1/contrib/seg/sql/
H A Dseg.sql214 CREATE TABLE test_seg (s seg); table
216 \copy test_seg from 'data/test_seg.data'
218 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
222 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
223 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
228 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
229 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
233 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
237 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
/dports/databases/postgresql13-pltcl/postgresql-13.5/contrib/seg/sql/
H A Dseg.sql214 CREATE TABLE test_seg (s seg); table
216 \copy test_seg from 'data/test_seg.data'
218 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
222 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
223 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
228 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
229 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
233 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
237 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
/dports/databases/postgresql14-client/postgresql-14.1/contrib/seg/sql/
H A Dseg.sql214 CREATE TABLE test_seg (s seg);
216 \copy test_seg from 'data/test_seg.data'
218 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
222 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
223 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
228 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
229 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
233 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
237 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
/dports/databases/postgresql13-server/postgresql-13.5/contrib/seg/sql/
H A Dseg.sql214 CREATE TABLE test_seg (s seg); table
216 \copy test_seg from 'data/test_seg.data'
218 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
222 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
223 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
228 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
229 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
233 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
237 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
/dports/databases/postgresql14-docs/postgresql-14.1/contrib/seg/sql/
H A Dseg.sql214 CREATE TABLE test_seg (s seg); table
216 \copy test_seg from 'data/test_seg.data'
218 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
222 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
223 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
228 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
229 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
233 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
237 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
/dports/databases/postgresql14-contrib/postgresql-14.1/contrib/seg/sql/
H A Dseg.sql214 CREATE TABLE test_seg (s seg); table
216 \copy test_seg from 'data/test_seg.data'
218 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
222 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
223 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
228 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
229 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
233 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
237 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
/dports/databases/postgresql13-docs/postgresql-13.5/contrib/seg/sql/
H A Dseg.sql214 CREATE TABLE test_seg (s seg); table
216 \copy test_seg from 'data/test_seg.data'
218 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
222 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
223 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
228 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
229 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
233 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
237 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
/dports/databases/postgresql12-contrib/postgresql-12.9/contrib/seg/sql/
H A Dseg.sql214 CREATE TABLE test_seg (s seg); table
216 \copy test_seg from 'data/test_seg.data'
218 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
222 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
223 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
228 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
229 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
233 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
237 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
/dports/databases/postgresql13-client/postgresql-13.5/contrib/seg/sql/
H A Dseg.sql214 CREATE TABLE test_seg (s seg); table
216 \copy test_seg from 'data/test_seg.data'
218 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
222 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
223 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
228 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
229 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
233 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
237 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
/dports/databases/postgresql13-contrib/postgresql-13.5/contrib/seg/sql/
H A Dseg.sql214 CREATE TABLE test_seg (s seg);
216 \copy test_seg from 'data/test_seg.data'
218 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
222 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
223 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
228 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
229 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
233 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
237 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
/dports/databases/postgresql12-plperl/postgresql-12.9/contrib/seg/sql/
H A Dseg.sql214 CREATE TABLE test_seg (s seg); table
216 \copy test_seg from 'data/test_seg.data'
218 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
222 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
223 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
228 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
229 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
233 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
237 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
/dports/databases/postgresql12-plpython/postgresql-12.9/contrib/seg/sql/
H A Dseg.sql214 CREATE TABLE test_seg (s seg); table
216 \copy test_seg from 'data/test_seg.data'
218 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
222 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
223 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
228 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
229 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
233 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
237 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
/dports/databases/postgresql12-docs/postgresql-12.9/contrib/seg/sql/
H A Dseg.sql214 CREATE TABLE test_seg (s seg); table
216 \copy test_seg from 'data/test_seg.data'
218 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
222 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
223 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
228 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
229 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
233 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
237 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;
/dports/databases/postgresql12-pltcl/postgresql-12.9/contrib/seg/sql/
H A Dseg.sql214 CREATE TABLE test_seg (s seg); table
216 \copy test_seg from 'data/test_seg.data'
218 CREATE INDEX test_seg_ix ON test_seg USING gist (s);
222 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
223 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
228 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
229 SELECT count(*) FROM test_seg WHERE s @> '11..11.3';
233 SELECT * FROM test_seg WHERE s @> '11..11.3' GROUP BY s;
237 FROM test_seg WHERE s @> '11.2..11.3' OR s IS NULL ORDER BY s;

123456