/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/ |
H A D | rangetypes.sql | 364 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 D | rangetypes.sql | 121 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 D | rangetypes.sql | 121 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 D | rangetypes.sql | 121 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 D | rangetypes.sql | 121 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 D | rangetypes.sql | 121 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 D | rangetypes.sql | 121 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 D | rangetypes.sql | 121 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 D | rangetypes.sql | 121 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 D | rangetypes.sql | 121 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 D | rangetypes.sql | 121 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 D | rangetypes.sql | 121 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 D | rangetypes.sql | 121 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 D | rangetypes.sql | 121 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 D | rangetypes.sql | 121 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 D | rangetypes.sql | 121 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 D | rangetypes.sql | 121 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 D | rangetypes.sql | 121 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 D | rangetypes.sql | 121 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 D | rangetypes.sql | 121 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 D | rangetypes.sql | 121 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 D | rangetypes.sql | 121 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 D | rangetypes.sql | 121 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 D | rangetypes.sql | 121 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 D | rangetypes.sql | 121 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 …]
|