Home
last modified time | relevance | path

Searched refs:trunc_stats_test1 (Results 1 – 25 of 86) sorted by relevance

1234

/dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/sql/
H A Dstats.sql79 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 Dstats.sql79 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 Dstats.sql110 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 Dstats.sql82 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 Dstats.sql79 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 Dstats.sql79 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 Dstats.sql82 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 Dstats.sql82 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 Dstats.sql82 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 Dstats.sql82 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 Dstats.sql82 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 Dstats.sql82 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 Dstats.sql82 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 Dstats.sql82 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 Dstats.sql82 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 Dstats.sql82 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 Dstats.sql82 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 Dstats.sql82 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 Dstats.sql82 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 Dstats.sql82 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 Dstats.sql82 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 Dstats.sql82 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 Dstats.sql82 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 Dstats.sql82 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 Dstats.sql82 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…

1234