Home
last modified time | relevance | path

Searched refs:level1_no (Results 1 – 25 of 72) sorted by relevance

123

/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/
H A Dplpgsql.sql6374 level1_no serial NOT NULL, field
6417 level1_no,
6421 level1_no,
6427 level1_no,
6432 level1_no
6437 level1_no
6462 p.level1_no IS NULL;
6492 level1_no,
6528 WHERE level1_no = 25;
6532 level1_no = - 1
[all …]
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/
H A Dplpgsql.sql4211 level1_no serial NOT NULL , field
4213 PRIMARY KEY (level1_no)
4259 WITH p AS (SELECT level1_no, sum(delta) cnt
4263 GROUP BY level1_no
4265 SELECT level1_no
4288 ON p.level1_no IS NOT NULL AND p.level1_no = i.parent_no
4289 WHERE p.level1_no IS NULL;
4326 INSERT INTO transition_table_level1(level1_no)
4355 WHERE level1_no = 25;
4358 WHERE level1_no = 30;
[all …]
/dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/
H A Dplpgsql.sql4286 level1_no serial NOT NULL , field
4288 PRIMARY KEY (level1_no)
4334 WITH p AS (SELECT level1_no, sum(delta) cnt
4338 GROUP BY level1_no
4340 SELECT level1_no
4363 ON p.level1_no IS NOT NULL AND p.level1_no = i.parent_no
4364 WHERE p.level1_no IS NULL;
4401 INSERT INTO transition_table_level1(level1_no)
4430 WHERE level1_no = 25;
4433 WHERE level1_no = 30;
[all …]
/dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/
H A Dplpgsql.sql4286 level1_no serial NOT NULL , field
4288 PRIMARY KEY (level1_no)
4334 WITH p AS (SELECT level1_no, sum(delta) cnt
4338 GROUP BY level1_no
4340 SELECT level1_no
4363 ON p.level1_no IS NOT NULL AND p.level1_no = i.parent_no
4364 WHERE p.level1_no IS NULL;
4401 INSERT INTO transition_table_level1(level1_no)
4430 WHERE level1_no = 25;
4433 WHERE level1_no = 30;
[all …]
/dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/
H A Dplpgsql.sql4286 level1_no serial NOT NULL , field
4288 PRIMARY KEY (level1_no)
4334 WITH p AS (SELECT level1_no, sum(delta) cnt
4338 GROUP BY level1_no
4340 SELECT level1_no
4363 ON p.level1_no IS NOT NULL AND p.level1_no = i.parent_no
4364 WHERE p.level1_no IS NULL;
4401 INSERT INTO transition_table_level1(level1_no)
4430 WHERE level1_no = 25;
4433 WHERE level1_no = 30;
[all …]
/dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/
H A Dplpgsql.sql4286 level1_no serial NOT NULL , field
4288 PRIMARY KEY (level1_no)
4334 WITH p AS (SELECT level1_no, sum(delta) cnt
4338 GROUP BY level1_no
4340 SELECT level1_no
4363 ON p.level1_no IS NOT NULL AND p.level1_no = i.parent_no
4364 WHERE p.level1_no IS NULL;
4401 INSERT INTO transition_table_level1(level1_no)
4430 WHERE level1_no = 25;
4433 WHERE level1_no = 30;
[all …]
/dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/sql/
H A Dplpgsql.sql4286 level1_no serial NOT NULL ,
4288 PRIMARY KEY (level1_no)
4334 WITH p AS (SELECT level1_no, sum(delta) cnt
4338 GROUP BY level1_no
4340 SELECT level1_no
4363 ON p.level1_no IS NOT NULL AND p.level1_no = i.parent_no
4364 WHERE p.level1_no IS NULL;
4401 INSERT INTO transition_table_level1(level1_no)
4430 WHERE level1_no = 25;
4433 WHERE level1_no = 30;
[all …]
/dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/sql/
H A Dplpgsql.sql4286 level1_no serial NOT NULL , field
4288 PRIMARY KEY (level1_no)
4334 WITH p AS (SELECT level1_no, sum(delta) cnt
4338 GROUP BY level1_no
4340 SELECT level1_no
4363 ON p.level1_no IS NOT NULL AND p.level1_no = i.parent_no
4364 WHERE p.level1_no IS NULL;
4401 INSERT INTO transition_table_level1(level1_no)
4430 WHERE level1_no = 25;
4433 WHERE level1_no = 30;
[all …]
/dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/
H A Dplpgsql.sql4216 level1_no serial NOT NULL , field
4218 PRIMARY KEY (level1_no)
4264 WITH p AS (SELECT level1_no, sum(delta) cnt
4268 GROUP BY level1_no
4270 SELECT level1_no
4293 ON p.level1_no IS NOT NULL AND p.level1_no = i.parent_no
4294 WHERE p.level1_no IS NULL;
4331 INSERT INTO transition_table_level1(level1_no)
4360 WHERE level1_no = 25;
4363 WHERE level1_no = 30;
[all …]
/dports/databases/postgresql11-server/postgresql-11.14/src/test/regress/sql/
H A Dplpgsql.sql4286 level1_no serial NOT NULL , field
4288 PRIMARY KEY (level1_no)
4334 WITH p AS (SELECT level1_no, sum(delta) cnt
4338 GROUP BY level1_no
4340 SELECT level1_no
4363 ON p.level1_no IS NOT NULL AND p.level1_no = i.parent_no
4364 WHERE p.level1_no IS NULL;
4401 INSERT INTO transition_table_level1(level1_no)
4430 WHERE level1_no = 25;
4433 WHERE level1_no = 30;
[all …]
/dports/databases/postgresql12-contrib/postgresql-12.9/src/test/regress/sql/
H A Dplpgsql.sql4216 level1_no serial NOT NULL , field
4218 PRIMARY KEY (level1_no)
4264 WITH p AS (SELECT level1_no, sum(delta) cnt
4268 GROUP BY level1_no
4270 SELECT level1_no
4293 ON p.level1_no IS NOT NULL AND p.level1_no = i.parent_no
4294 WHERE p.level1_no IS NULL;
4331 INSERT INTO transition_table_level1(level1_no)
4360 WHERE level1_no = 25;
4363 WHERE level1_no = 30;
[all …]
/dports/databases/postgresql12-docs/postgresql-12.9/src/test/regress/sql/
H A Dplpgsql.sql4216 level1_no serial NOT NULL , field
4218 PRIMARY KEY (level1_no)
4264 WITH p AS (SELECT level1_no, sum(delta) cnt
4268 GROUP BY level1_no
4270 SELECT level1_no
4293 ON p.level1_no IS NOT NULL AND p.level1_no = i.parent_no
4294 WHERE p.level1_no IS NULL;
4331 INSERT INTO transition_table_level1(level1_no)
4360 WHERE level1_no = 25;
4363 WHERE level1_no = 30;
[all …]
/dports/databases/postgresql12-server/postgresql-12.9/src/test/regress/sql/
H A Dplpgsql.sql4216 level1_no serial NOT NULL , field
4218 PRIMARY KEY (level1_no)
4264 WITH p AS (SELECT level1_no, sum(delta) cnt
4268 GROUP BY level1_no
4270 SELECT level1_no
4293 ON p.level1_no IS NOT NULL AND p.level1_no = i.parent_no
4294 WHERE p.level1_no IS NULL;
4331 INSERT INTO transition_table_level1(level1_no)
4360 WHERE level1_no = 25;
4363 WHERE level1_no = 30;
[all …]
/dports/databases/postgresql12-plperl/postgresql-12.9/src/test/regress/sql/
H A Dplpgsql.sql4216 level1_no serial NOT NULL , field
4218 PRIMARY KEY (level1_no)
4264 WITH p AS (SELECT level1_no, sum(delta) cnt
4268 GROUP BY level1_no
4270 SELECT level1_no
4293 ON p.level1_no IS NOT NULL AND p.level1_no = i.parent_no
4294 WHERE p.level1_no IS NULL;
4331 INSERT INTO transition_table_level1(level1_no)
4360 WHERE level1_no = 25;
4363 WHERE level1_no = 30;
[all …]
/dports/databases/postgresql12-plpython/postgresql-12.9/src/test/regress/sql/
H A Dplpgsql.sql4216 level1_no serial NOT NULL , field
4218 PRIMARY KEY (level1_no)
4264 WITH p AS (SELECT level1_no, sum(delta) cnt
4268 GROUP BY level1_no
4270 SELECT level1_no
4293 ON p.level1_no IS NOT NULL AND p.level1_no = i.parent_no
4294 WHERE p.level1_no IS NULL;
4331 INSERT INTO transition_table_level1(level1_no)
4360 WHERE level1_no = 25;
4363 WHERE level1_no = 30;
[all …]
/dports/databases/postgresql12-pltcl/postgresql-12.9/src/test/regress/sql/
H A Dplpgsql.sql4216 level1_no serial NOT NULL , field
4218 PRIMARY KEY (level1_no)
4264 WITH p AS (SELECT level1_no, sum(delta) cnt
4268 GROUP BY level1_no
4270 SELECT level1_no
4293 ON p.level1_no IS NOT NULL AND p.level1_no = i.parent_no
4294 WHERE p.level1_no IS NULL;
4331 INSERT INTO transition_table_level1(level1_no)
4360 WHERE level1_no = 25;
4363 WHERE level1_no = 30;
[all …]
/dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/
H A Dplpgsql.sql4556 level1_no serial NOT NULL , field
4558 PRIMARY KEY (level1_no)
4604 WITH p AS (SELECT level1_no, sum(delta) cnt
4608 GROUP BY level1_no
4610 SELECT level1_no
4633 ON p.level1_no IS NOT NULL AND p.level1_no = i.parent_no
4634 WHERE p.level1_no IS NULL;
4671 INSERT INTO transition_table_level1(level1_no)
4700 WHERE level1_no = 25;
4703 WHERE level1_no = 30;
[all …]
/dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/
H A Dplpgsql.sql4556 level1_no serial NOT NULL , field
4558 PRIMARY KEY (level1_no)
4604 WITH p AS (SELECT level1_no, sum(delta) cnt
4608 GROUP BY level1_no
4610 SELECT level1_no
4633 ON p.level1_no IS NOT NULL AND p.level1_no = i.parent_no
4634 WHERE p.level1_no IS NULL;
4671 INSERT INTO transition_table_level1(level1_no)
4700 WHERE level1_no = 25;
4703 WHERE level1_no = 30;
[all …]
/dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/
H A Dplpgsql.sql4556 level1_no serial NOT NULL , field
4558 PRIMARY KEY (level1_no)
4604 WITH p AS (SELECT level1_no, sum(delta) cnt
4608 GROUP BY level1_no
4610 SELECT level1_no
4633 ON p.level1_no IS NOT NULL AND p.level1_no = i.parent_no
4634 WHERE p.level1_no IS NULL;
4671 INSERT INTO transition_table_level1(level1_no)
4700 WHERE level1_no = 25;
4703 WHERE level1_no = 30;
[all …]
/dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/
H A Dplpgsql.sql4556 level1_no serial NOT NULL , field
4558 PRIMARY KEY (level1_no)
4604 WITH p AS (SELECT level1_no, sum(delta) cnt
4608 GROUP BY level1_no
4610 SELECT level1_no
4633 ON p.level1_no IS NOT NULL AND p.level1_no = i.parent_no
4634 WHERE p.level1_no IS NULL;
4671 INSERT INTO transition_table_level1(level1_no)
4700 WHERE level1_no = 25;
4703 WHERE level1_no = 30;
[all …]
/dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/
H A Dplpgsql.sql4556 level1_no serial NOT NULL , field
4558 PRIMARY KEY (level1_no)
4604 WITH p AS (SELECT level1_no, sum(delta) cnt
4608 GROUP BY level1_no
4610 SELECT level1_no
4633 ON p.level1_no IS NOT NULL AND p.level1_no = i.parent_no
4634 WHERE p.level1_no IS NULL;
4671 INSERT INTO transition_table_level1(level1_no)
4700 WHERE level1_no = 25;
4703 WHERE level1_no = 30;
[all …]
/dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/sql/
H A Dplpgsql.sql4556 level1_no serial NOT NULL , field
4558 PRIMARY KEY (level1_no)
4604 WITH p AS (SELECT level1_no, sum(delta) cnt
4608 GROUP BY level1_no
4610 SELECT level1_no
4633 ON p.level1_no IS NOT NULL AND p.level1_no = i.parent_no
4634 WHERE p.level1_no IS NULL;
4671 INSERT INTO transition_table_level1(level1_no)
4700 WHERE level1_no = 25;
4703 WHERE level1_no = 30;
[all …]
/dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/sql/
H A Dplpgsql.sql4556 level1_no serial NOT NULL , field
4558 PRIMARY KEY (level1_no)
4604 WITH p AS (SELECT level1_no, sum(delta) cnt
4608 GROUP BY level1_no
4610 SELECT level1_no
4633 ON p.level1_no IS NOT NULL AND p.level1_no = i.parent_no
4634 WHERE p.level1_no IS NULL;
4671 INSERT INTO transition_table_level1(level1_no)
4700 WHERE level1_no = 25;
4703 WHERE level1_no = 30;
[all …]
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/
H A Dplpgsql.sql4377 level1_no serial NOT NULL , field
4379 PRIMARY KEY (level1_no)
4425 WITH p AS (SELECT level1_no, sum(delta) cnt
4429 GROUP BY level1_no
4431 SELECT level1_no
4454 ON p.level1_no IS NOT NULL AND p.level1_no = i.parent_no
4455 WHERE p.level1_no IS NULL;
4492 INSERT INTO transition_table_level1(level1_no)
4521 WHERE level1_no = 25;
4524 WHERE level1_no = 30;
[all …]
/dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/
H A Dplpgsql.sql4377 level1_no serial NOT NULL , field
4379 PRIMARY KEY (level1_no)
4425 WITH p AS (SELECT level1_no, sum(delta) cnt
4429 GROUP BY level1_no
4431 SELECT level1_no
4454 ON p.level1_no IS NOT NULL AND p.level1_no = i.parent_no
4455 WHERE p.level1_no IS NULL;
4492 INSERT INTO transition_table_level1(level1_no)
4521 WHERE level1_no = 25;
4524 WHERE level1_no = 30;
[all …]

123