Home
last modified time | relevance | path

Searched refs:numrange_test2 (Results 1 – 25 of 89) sorted by relevance

1234

/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/
H A Drangetypes.sql364 CREATE TABLE numrange_test2 ( table
370 INSERT INTO numrange_test2
373 INSERT INTO numrange_test2
376 INSERT INTO numrange_test2
379 INSERT INTO numrange_test2
382 INSERT INTO numrange_test2
388 numrange_test2
395 numrange_test2
402 numrange_test2
416 NATURAL JOIN numrange_test2
[all …]
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/
H A Drangetypes.sql121 create table numrange_test2(nr numrange); table
122 create index numrange_test2_hash_idx on numrange_test2 (nr);
124 INSERT INTO numrange_test2 VALUES('[, 5)');
125 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
126 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
127 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));
128 INSERT INTO numrange_test2 VALUES('empty');
130 select * from numrange_test2 where nr = 'empty'::numrange;
131 select * from numrange_test2 where nr = numrange(1.1, 2.2);
132 select * from numrange_test2 where nr = numrange(1.1, 2.3);
[all …]
/dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/sql/
H A Drangetypes.sql121 create table numrange_test2(nr numrange); table
124 INSERT INTO numrange_test2 VALUES('[, 5)');
125 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
126 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
127 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));
128 INSERT INTO numrange_test2 VALUES('empty');
130 select * from numrange_test2 where nr = 'empty'::numrange;
131 select * from numrange_test2 where nr = numrange(1.1, 2.2);
132 select * from numrange_test2 where nr = numrange(1.1, 2.3);
137 select * from numrange_test natural join numrange_test2 order by nr;
[all …]
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/test/regress/sql/
H A Drangetypes.sql121 create table numrange_test2(nr numrange); table
124 INSERT INTO numrange_test2 VALUES('[, 5)');
125 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
126 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
127 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));
128 INSERT INTO numrange_test2 VALUES('empty');
130 select * from numrange_test2 where nr = 'empty'::numrange;
131 select * from numrange_test2 where nr = numrange(1.1, 2.2);
132 select * from numrange_test2 where nr = numrange(1.1, 2.3);
137 select * from numrange_test natural join numrange_test2 order by nr;
[all …]
/dports/databases/postgresql96-plperl/postgresql-9.6.24/src/test/regress/sql/
H A Drangetypes.sql121 create table numrange_test2(nr numrange); table
124 INSERT INTO numrange_test2 VALUES('[, 5)');
125 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
126 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
127 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));
128 INSERT INTO numrange_test2 VALUES('empty');
130 select * from numrange_test2 where nr = 'empty'::numrange;
131 select * from numrange_test2 where nr = numrange(1.1, 2.2);
132 select * from numrange_test2 where nr = numrange(1.1, 2.3);
137 select * from numrange_test natural join numrange_test2 order by nr;
[all …]
/dports/databases/postgresql96-plpython/postgresql-9.6.24/src/test/regress/sql/
H A Drangetypes.sql121 create table numrange_test2(nr numrange); table
124 INSERT INTO numrange_test2 VALUES('[, 5)');
125 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
126 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
127 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));
128 INSERT INTO numrange_test2 VALUES('empty');
130 select * from numrange_test2 where nr = 'empty'::numrange;
131 select * from numrange_test2 where nr = numrange(1.1, 2.2);
132 select * from numrange_test2 where nr = numrange(1.1, 2.3);
137 select * from numrange_test natural join numrange_test2 order by nr;
[all …]
/dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/
H A Drangetypes.sql121 create table numrange_test2(nr numrange); table
124 INSERT INTO numrange_test2 VALUES('[, 5)');
125 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
126 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
127 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));
128 INSERT INTO numrange_test2 VALUES('empty');
130 select * from numrange_test2 where nr = 'empty'::numrange;
131 select * from numrange_test2 where nr = numrange(1.1, 2.2);
132 select * from numrange_test2 where nr = numrange(1.1, 2.3);
137 select * from numrange_test natural join numrange_test2 order by nr;
[all …]
/dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/
H A Drangetypes.sql121 create table numrange_test2(nr numrange); table
124 INSERT INTO numrange_test2 VALUES('[, 5)');
125 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
126 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
127 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));
128 INSERT INTO numrange_test2 VALUES('empty');
130 select * from numrange_test2 where nr = 'empty'::numrange;
131 select * from numrange_test2 where nr = numrange(1.1, 2.2);
132 select * from numrange_test2 where nr = numrange(1.1, 2.3);
137 select * from numrange_test natural join numrange_test2 order by nr;
[all …]
/dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/
H A Drangetypes.sql121 create table numrange_test2(nr numrange); table
124 INSERT INTO numrange_test2 VALUES('[, 5)');
125 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
126 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
127 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));
128 INSERT INTO numrange_test2 VALUES('empty');
130 select * from numrange_test2 where nr = 'empty'::numrange;
131 select * from numrange_test2 where nr = numrange(1.1, 2.2);
132 select * from numrange_test2 where nr = numrange(1.1, 2.3);
137 select * from numrange_test natural join numrange_test2 order by nr;
[all …]
/dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/
H A Drangetypes.sql121 create table numrange_test2(nr numrange); table
124 INSERT INTO numrange_test2 VALUES('[, 5)');
125 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
126 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
127 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));
128 INSERT INTO numrange_test2 VALUES('empty');
130 select * from numrange_test2 where nr = 'empty'::numrange;
131 select * from numrange_test2 where nr = numrange(1.1, 2.2);
132 select * from numrange_test2 where nr = numrange(1.1, 2.3);
137 select * from numrange_test natural join numrange_test2 order by nr;
[all …]
/dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/
H A Drangetypes.sql121 create table numrange_test2(nr numrange); table
124 INSERT INTO numrange_test2 VALUES('[, 5)');
125 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
126 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
127 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));
128 INSERT INTO numrange_test2 VALUES('empty');
130 select * from numrange_test2 where nr = 'empty'::numrange;
131 select * from numrange_test2 where nr = numrange(1.1, 2.2);
132 select * from numrange_test2 where nr = numrange(1.1, 2.3);
137 select * from numrange_test natural join numrange_test2 order by nr;
[all …]
/dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/
H A Drangetypes.sql121 create table numrange_test2(nr numrange); table
124 INSERT INTO numrange_test2 VALUES('[, 5)');
125 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
126 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
127 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));
128 INSERT INTO numrange_test2 VALUES('empty');
130 select * from numrange_test2 where nr = 'empty'::numrange;
131 select * from numrange_test2 where nr = numrange(1.1, 2.2);
132 select * from numrange_test2 where nr = numrange(1.1, 2.3);
137 select * from numrange_test natural join numrange_test2 order by nr;
[all …]
/dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/
H A Drangetypes.sql121 create table numrange_test2(nr numrange); table
124 INSERT INTO numrange_test2 VALUES('[, 5)');
125 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
126 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
127 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));
128 INSERT INTO numrange_test2 VALUES('empty');
130 select * from numrange_test2 where nr = 'empty'::numrange;
131 select * from numrange_test2 where nr = numrange(1.1, 2.2);
132 select * from numrange_test2 where nr = numrange(1.1, 2.3);
137 select * from numrange_test natural join numrange_test2 order by nr;
[all …]
/dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/
H A Drangetypes.sql121 create table numrange_test2(nr numrange); table
124 INSERT INTO numrange_test2 VALUES('[, 5)');
125 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
126 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
127 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));
128 INSERT INTO numrange_test2 VALUES('empty');
130 select * from numrange_test2 where nr = 'empty'::numrange;
131 select * from numrange_test2 where nr = numrange(1.1, 2.2);
132 select * from numrange_test2 where nr = numrange(1.1, 2.3);
137 select * from numrange_test natural join numrange_test2 order by nr;
[all …]
/dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/
H A Drangetypes.sql121 create table numrange_test2(nr numrange); table
124 INSERT INTO numrange_test2 VALUES('[, 5)');
125 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
126 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
127 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));
128 INSERT INTO numrange_test2 VALUES('empty');
130 select * from numrange_test2 where nr = 'empty'::numrange;
131 select * from numrange_test2 where nr = numrange(1.1, 2.2);
132 select * from numrange_test2 where nr = numrange(1.1, 2.3);
137 select * from numrange_test natural join numrange_test2 order by nr;
[all …]
/dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/sql/
H A Drangetypes.sql121 create table numrange_test2(nr numrange); table
124 INSERT INTO numrange_test2 VALUES('[, 5)');
125 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
126 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
127 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));
128 INSERT INTO numrange_test2 VALUES('empty');
130 select * from numrange_test2 where nr = 'empty'::numrange;
131 select * from numrange_test2 where nr = numrange(1.1, 2.2);
132 select * from numrange_test2 where nr = numrange(1.1, 2.3);
137 select * from numrange_test natural join numrange_test2 order by nr;
[all …]
/dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/sql/
H A Drangetypes.sql121 create table numrange_test2(nr numrange); table
124 INSERT INTO numrange_test2 VALUES('[, 5)');
125 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
126 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
127 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));
128 INSERT INTO numrange_test2 VALUES('empty');
130 select * from numrange_test2 where nr = 'empty'::numrange;
131 select * from numrange_test2 where nr = numrange(1.1, 2.2);
132 select * from numrange_test2 where nr = numrange(1.1, 2.3);
137 select * from numrange_test natural join numrange_test2 order by nr;
[all …]
/dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/
H A Drangetypes.sql121 create table numrange_test2(nr numrange); table
124 INSERT INTO numrange_test2 VALUES('[, 5)');
125 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
126 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
127 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));
128 INSERT INTO numrange_test2 VALUES('empty');
130 select * from numrange_test2 where nr = 'empty'::numrange;
131 select * from numrange_test2 where nr = numrange(1.1, 2.2);
132 select * from numrange_test2 where nr = numrange(1.1, 2.3);
137 select * from numrange_test natural join numrange_test2 order by nr;
[all …]
/dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/sql/
H A Drangetypes.sql121 create table numrange_test2(nr numrange); table
124 INSERT INTO numrange_test2 VALUES('[, 5)');
125 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
126 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
127 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));
128 INSERT INTO numrange_test2 VALUES('empty');
130 select * from numrange_test2 where nr = 'empty'::numrange;
131 select * from numrange_test2 where nr = numrange(1.1, 2.2);
132 select * from numrange_test2 where nr = numrange(1.1, 2.3);
137 select * from numrange_test natural join numrange_test2 order by nr;
[all …]
/dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/sql/
H A Drangetypes.sql121 create table numrange_test2(nr numrange);
124 INSERT INTO numrange_test2 VALUES('[, 5)');
125 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
126 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
127 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));
128 INSERT INTO numrange_test2 VALUES('empty');
130 select * from numrange_test2 where nr = 'empty'::numrange;
131 select * from numrange_test2 where nr = numrange(1.1, 2.2);
132 select * from numrange_test2 where nr = numrange(1.1, 2.3);
137 select * from numrange_test natural join numrange_test2 order by nr;
[all …]
/dports/databases/postgresql13-plpython/postgresql-13.5/src/test/regress/sql/
H A Drangetypes.sql121 create table numrange_test2(nr numrange); table
124 INSERT INTO numrange_test2 VALUES('[, 5)');
125 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
126 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
127 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));
128 INSERT INTO numrange_test2 VALUES('empty');
130 select * from numrange_test2 where nr = 'empty'::numrange;
131 select * from numrange_test2 where nr = numrange(1.1, 2.2);
132 select * from numrange_test2 where nr = numrange(1.1, 2.3);
137 select * from numrange_test natural join numrange_test2 order by nr;
[all …]
/dports/databases/postgresql13-pltcl/postgresql-13.5/src/test/regress/sql/
H A Drangetypes.sql121 create table numrange_test2(nr numrange); table
124 INSERT INTO numrange_test2 VALUES('[, 5)');
125 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
126 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
127 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));
128 INSERT INTO numrange_test2 VALUES('empty');
130 select * from numrange_test2 where nr = 'empty'::numrange;
131 select * from numrange_test2 where nr = numrange(1.1, 2.2);
132 select * from numrange_test2 where nr = numrange(1.1, 2.3);
137 select * from numrange_test natural join numrange_test2 order by nr;
[all …]
/dports/databases/postgresql13-server/postgresql-13.5/src/test/regress/sql/
H A Drangetypes.sql121 create table numrange_test2(nr numrange); table
124 INSERT INTO numrange_test2 VALUES('[, 5)');
125 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
126 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
127 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));
128 INSERT INTO numrange_test2 VALUES('empty');
130 select * from numrange_test2 where nr = 'empty'::numrange;
131 select * from numrange_test2 where nr = numrange(1.1, 2.2);
132 select * from numrange_test2 where nr = numrange(1.1, 2.3);
137 select * from numrange_test natural join numrange_test2 order by nr;
[all …]
/dports/databases/postgresql96-docs/postgresql-9.6.24/src/test/regress/sql/
H A Drangetypes.sql121 create table numrange_test2(nr numrange); table
124 INSERT INTO numrange_test2 VALUES('[, 5)');
125 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
126 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
127 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));
128 INSERT INTO numrange_test2 VALUES('empty');
130 select * from numrange_test2 where nr = 'empty'::numrange;
131 select * from numrange_test2 where nr = numrange(1.1, 2.2);
132 select * from numrange_test2 where nr = numrange(1.1, 2.3);
137 select * from numrange_test natural join numrange_test2 order by nr;
[all …]
/dports/databases/postgresql96-contrib/postgresql-9.6.24/src/test/regress/sql/
H A Drangetypes.sql121 create table numrange_test2(nr numrange); table
124 INSERT INTO numrange_test2 VALUES('[, 5)');
125 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
126 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));
127 INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));
128 INSERT INTO numrange_test2 VALUES('empty');
130 select * from numrange_test2 where nr = 'empty'::numrange;
131 select * from numrange_test2 where nr = numrange(1.1, 2.2);
132 select * from numrange_test2 where nr = numrange(1.1, 2.3);
137 select * from numrange_test natural join numrange_test2 order by nr;
[all …]

1234