/dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/sql/ |
H A D | stats.sql | 79 CREATE TABLE trunc_stats_test1(id serial, stuff text); table 91 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 92 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 93 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 94 UPDATE trunc_stats_test1 SET id = id + 10 WHERE id IN (1, 2); 95 DELETE FROM trunc_stats_test1 WHERE id = 3; 98 UPDATE trunc_stats_test1 SET id = id + 100; 99 TRUNCATE trunc_stats_test1; 100 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 167 DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_t…
|
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/test/regress/sql/ |
H A D | stats.sql | 79 CREATE TABLE trunc_stats_test1(id serial, stuff text); table 91 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 92 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 93 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 94 UPDATE trunc_stats_test1 SET id = id + 10 WHERE id IN (1, 2); 95 DELETE FROM trunc_stats_test1 WHERE id = 3; 98 UPDATE trunc_stats_test1 SET id = id + 100; 99 TRUNCATE trunc_stats_test1; 100 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 167 DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_t…
|
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/ |
H A D | stats.sql | 110 CREATE TABLE trunc_stats_test1 ( table 132 INSERT INTO trunc_stats_test1 DEFAULT VALUES; INSERT INTO trunc_stats_test1 DEFAULT VALUES; INSERT … 133 trunc_stats_test1 139 DELETE FROM trunc_stats_test1 144 trunc_stats_test1 147 TRUNCATE trunc_stats_test1; 148 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 248 DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_t…
|
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/ |
H A D | stats.sql | 82 CREATE TABLE trunc_stats_test1(id serial, stuff text); table 94 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 95 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 96 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 97 UPDATE trunc_stats_test1 SET id = id + 10 WHERE id IN (1, 2); 98 DELETE FROM trunc_stats_test1 WHERE id = 3; 101 UPDATE trunc_stats_test1 SET id = id + 100; 102 TRUNCATE trunc_stats_test1; 103 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 177 DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_t…
|
/dports/databases/postgresql96-plperl/postgresql-9.6.24/src/test/regress/sql/ |
H A D | stats.sql | 79 CREATE TABLE trunc_stats_test1(id serial, stuff text); table 91 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 92 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 93 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 94 UPDATE trunc_stats_test1 SET id = id + 10 WHERE id IN (1, 2); 95 DELETE FROM trunc_stats_test1 WHERE id = 3; 98 UPDATE trunc_stats_test1 SET id = id + 100; 99 TRUNCATE trunc_stats_test1; 100 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 167 DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_t…
|
/dports/databases/postgresql96-plpython/postgresql-9.6.24/src/test/regress/sql/ |
H A D | stats.sql | 79 CREATE TABLE trunc_stats_test1(id serial, stuff text); table 91 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 92 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 93 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 94 UPDATE trunc_stats_test1 SET id = id + 10 WHERE id IN (1, 2); 95 DELETE FROM trunc_stats_test1 WHERE id = 3; 98 UPDATE trunc_stats_test1 SET id = id + 100; 99 TRUNCATE trunc_stats_test1; 100 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 167 DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_t…
|
/dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/ |
H A D | stats.sql | 82 CREATE TABLE trunc_stats_test1(id serial, stuff text); table 94 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 95 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 96 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 97 UPDATE trunc_stats_test1 SET id = id + 10 WHERE id IN (1, 2); 98 DELETE FROM trunc_stats_test1 WHERE id = 3; 101 UPDATE trunc_stats_test1 SET id = id + 100; 102 TRUNCATE trunc_stats_test1; 103 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 174 DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_t…
|
/dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/ |
H A D | stats.sql | 82 CREATE TABLE trunc_stats_test1(id serial, stuff text); table 94 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 95 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 96 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 97 UPDATE trunc_stats_test1 SET id = id + 10 WHERE id IN (1, 2); 98 DELETE FROM trunc_stats_test1 WHERE id = 3; 101 UPDATE trunc_stats_test1 SET id = id + 100; 102 TRUNCATE trunc_stats_test1; 103 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 174 DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_t…
|
/dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/ |
H A D | stats.sql | 82 CREATE TABLE trunc_stats_test1(id serial, stuff text); table 94 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 95 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 96 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 97 UPDATE trunc_stats_test1 SET id = id + 10 WHERE id IN (1, 2); 98 DELETE FROM trunc_stats_test1 WHERE id = 3; 101 UPDATE trunc_stats_test1 SET id = id + 100; 102 TRUNCATE trunc_stats_test1; 103 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 174 DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_t…
|
/dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/ |
H A D | stats.sql | 82 CREATE TABLE trunc_stats_test1(id serial, stuff text); table 94 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 95 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 96 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 97 UPDATE trunc_stats_test1 SET id = id + 10 WHERE id IN (1, 2); 98 DELETE FROM trunc_stats_test1 WHERE id = 3; 101 UPDATE trunc_stats_test1 SET id = id + 100; 102 TRUNCATE trunc_stats_test1; 103 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 174 DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_t…
|
/dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/ |
H A D | stats.sql | 82 CREATE TABLE trunc_stats_test1(id serial, stuff text); table 94 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 95 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 96 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 97 UPDATE trunc_stats_test1 SET id = id + 10 WHERE id IN (1, 2); 98 DELETE FROM trunc_stats_test1 WHERE id = 3; 101 UPDATE trunc_stats_test1 SET id = id + 100; 102 TRUNCATE trunc_stats_test1; 103 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 174 DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_t…
|
/dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/ |
H A D | stats.sql | 82 CREATE TABLE trunc_stats_test1(id serial, stuff text); table 94 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 95 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 96 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 97 UPDATE trunc_stats_test1 SET id = id + 10 WHERE id IN (1, 2); 98 DELETE FROM trunc_stats_test1 WHERE id = 3; 101 UPDATE trunc_stats_test1 SET id = id + 100; 102 TRUNCATE trunc_stats_test1; 103 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 177 DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_t…
|
/dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/ |
H A D | stats.sql | 82 CREATE TABLE trunc_stats_test1(id serial, stuff text); 94 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 95 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 96 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 97 UPDATE trunc_stats_test1 SET id = id + 10 WHERE id IN (1, 2); 98 DELETE FROM trunc_stats_test1 WHERE id = 3; 101 UPDATE trunc_stats_test1 SET id = id + 100; 102 TRUNCATE trunc_stats_test1; 103 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 177 DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_t…
|
/dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/ |
H A D | stats.sql | 82 CREATE TABLE trunc_stats_test1(id serial, stuff text); table 94 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 95 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 96 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 97 UPDATE trunc_stats_test1 SET id = id + 10 WHERE id IN (1, 2); 98 DELETE FROM trunc_stats_test1 WHERE id = 3; 101 UPDATE trunc_stats_test1 SET id = id + 100; 102 TRUNCATE trunc_stats_test1; 103 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 177 DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_t…
|
/dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/ |
H A D | stats.sql | 82 CREATE TABLE trunc_stats_test1(id serial, stuff text); table 94 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 95 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 96 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 97 UPDATE trunc_stats_test1 SET id = id + 10 WHERE id IN (1, 2); 98 DELETE FROM trunc_stats_test1 WHERE id = 3; 101 UPDATE trunc_stats_test1 SET id = id + 100; 102 TRUNCATE trunc_stats_test1; 103 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 177 DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_t…
|
/dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/sql/ |
H A D | stats.sql | 82 CREATE TABLE trunc_stats_test1(id serial, stuff text); table 94 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 95 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 96 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 97 UPDATE trunc_stats_test1 SET id = id + 10 WHERE id IN (1, 2); 98 DELETE FROM trunc_stats_test1 WHERE id = 3; 101 UPDATE trunc_stats_test1 SET id = id + 100; 102 TRUNCATE trunc_stats_test1; 103 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 174 DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_t…
|
/dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/sql/ |
H A D | stats.sql | 82 CREATE TABLE trunc_stats_test1(id serial, stuff text); table 94 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 95 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 96 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 97 UPDATE trunc_stats_test1 SET id = id + 10 WHERE id IN (1, 2); 98 DELETE FROM trunc_stats_test1 WHERE id = 3; 101 UPDATE trunc_stats_test1 SET id = id + 100; 102 TRUNCATE trunc_stats_test1; 103 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 174 DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_t…
|
/dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/ |
H A D | stats.sql | 82 CREATE TABLE trunc_stats_test1(id serial, stuff text); 94 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 95 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 96 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 97 UPDATE trunc_stats_test1 SET id = id + 10 WHERE id IN (1, 2); 98 DELETE FROM trunc_stats_test1 WHERE id = 3; 101 UPDATE trunc_stats_test1 SET id = id + 100; 102 TRUNCATE trunc_stats_test1; 103 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 177 DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_t…
|
/dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/sql/ |
H A D | stats.sql | 82 CREATE TABLE trunc_stats_test1(id serial, stuff text); 94 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 95 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 96 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 97 UPDATE trunc_stats_test1 SET id = id + 10 WHERE id IN (1, 2); 98 DELETE FROM trunc_stats_test1 WHERE id = 3; 101 UPDATE trunc_stats_test1 SET id = id + 100; 102 TRUNCATE trunc_stats_test1; 103 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 177 DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_t…
|
/dports/databases/postgresql11-server/postgresql-11.14/src/test/regress/sql/ |
H A D | stats.sql | 82 CREATE TABLE trunc_stats_test1(id serial, stuff text); table 94 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 95 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 96 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 97 UPDATE trunc_stats_test1 SET id = id + 10 WHERE id IN (1, 2); 98 DELETE FROM trunc_stats_test1 WHERE id = 3; 101 UPDATE trunc_stats_test1 SET id = id + 100; 102 TRUNCATE trunc_stats_test1; 103 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 177 DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_t…
|
/dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/sql/ |
H A D | stats.sql | 82 CREATE TABLE trunc_stats_test1(id serial, stuff text); 94 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 95 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 96 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 97 UPDATE trunc_stats_test1 SET id = id + 10 WHERE id IN (1, 2); 98 DELETE FROM trunc_stats_test1 WHERE id = 3; 101 UPDATE trunc_stats_test1 SET id = id + 100; 102 TRUNCATE trunc_stats_test1; 103 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 177 DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_t…
|
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/ |
H A D | stats.sql | 82 CREATE TABLE trunc_stats_test1(id serial, stuff text); table 94 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 95 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 96 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 97 UPDATE trunc_stats_test1 SET id = id + 10 WHERE id IN (1, 2); 98 DELETE FROM trunc_stats_test1 WHERE id = 3; 101 UPDATE trunc_stats_test1 SET id = id + 100; 102 TRUNCATE trunc_stats_test1; 103 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 177 DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_t…
|
/dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/ |
H A D | stats.sql | 82 CREATE TABLE trunc_stats_test1(id serial, stuff text); table 94 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 95 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 96 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 97 UPDATE trunc_stats_test1 SET id = id + 10 WHERE id IN (1, 2); 98 DELETE FROM trunc_stats_test1 WHERE id = 3; 101 UPDATE trunc_stats_test1 SET id = id + 100; 102 TRUNCATE trunc_stats_test1; 103 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 177 DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_t…
|
/dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/ |
H A D | stats.sql | 82 CREATE TABLE trunc_stats_test1(id serial, stuff text); table 94 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 95 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 96 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 97 UPDATE trunc_stats_test1 SET id = id + 10 WHERE id IN (1, 2); 98 DELETE FROM trunc_stats_test1 WHERE id = 3; 101 UPDATE trunc_stats_test1 SET id = id + 100; 102 TRUNCATE trunc_stats_test1; 103 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 177 DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_t…
|
/dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/sql/ |
H A D | stats.sql | 82 CREATE TABLE trunc_stats_test1(id serial, stuff text); table 94 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 95 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 96 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 97 UPDATE trunc_stats_test1 SET id = id + 10 WHERE id IN (1, 2); 98 DELETE FROM trunc_stats_test1 WHERE id = 3; 101 UPDATE trunc_stats_test1 SET id = id + 100; 102 TRUNCATE trunc_stats_test1; 103 INSERT INTO trunc_stats_test1 DEFAULT VALUES; 177 DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_t…
|