/dports/science/quantum-espresso/q-e-qe-6.7.0/EPW/examples/diamond/phonons/Ref/ |
H A D | ph.out | 56 Possibly too few bands at point 1 -0.06250 0.06250 0.06250 58 Possibly too few bands at point 2 -0.18750 0.18750 -0.06250 60 Possibly too few bands at point 3 -0.31250 0.31250 -0.18750 62 Possibly too few bands at point 4 -0.43750 0.43750 -0.31250 64 Possibly too few bands at point 5 0.43750 -0.43750 0.56250 66 Possibly too few bands at point 6 0.31250 -0.31250 0.43750 68 Possibly too few bands at point 7 0.18750 -0.18750 0.31250 70 Possibly too few bands at point 8 0.06250 -0.06250 0.18750 72 Possibly too few bands at point 9 -0.06250 0.31250 0.06250 74 Possibly too few bands at point 10 -0.18750 0.43750 -0.06250 [all …]
|
/dports/science/quantum-espresso/q-e-qe-6.7.0/PHonon/examples/Image_example/reference_1/ |
H A D | al.ph.disp.collect.out | 209 Possibly too few bands at point 1 0.00000 0.00000 0.00000 211 Possibly too few bands at point 2 -0.25000 0.25000 -0.25000 213 Possibly too few bands at point 3 -0.12500 0.12500 -0.12500 215 Possibly too few bands at point 4 -0.37500 0.37500 -0.37500 217 Possibly too few bands at point 5 -0.25000 0.25000 -0.25000 219 Possibly too few bands at point 6 -0.50000 0.50000 -0.50000 221 Possibly too few bands at point 7 -0.37500 0.37500 -0.37500 223 Possibly too few bands at point 8 -0.62500 0.62500 -0.62500 225 Possibly too few bands at point 9 0.50000 -0.50000 0.50000 227 Possibly too few bands at point 10 0.25000 -0.25000 0.25000 [all …]
|
H A D | al.ph.collect.out | 218 Possibly too few bands at point 1 0.00000 0.00000 0.00000 220 Possibly too few bands at point 2 0.25000 0.00000 0.00000 222 Possibly too few bands at point 3 -0.12500 0.12500 -0.12500 224 Possibly too few bands at point 4 0.12500 0.12500 -0.12500 226 Possibly too few bands at point 5 -0.25000 0.25000 -0.25000 228 Possibly too few bands at point 6 0.00000 0.25000 -0.25000 230 Possibly too few bands at point 7 -0.37500 0.37500 -0.37500 232 Possibly too few bands at point 8 -0.12500 0.37500 -0.37500 234 Possibly too few bands at point 9 0.50000 -0.50000 0.50000 236 Possibly too few bands at point 10 0.75000 -0.50000 0.50000 [all …]
|
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/ |
H A D | tsrf.sql | 38 SELECT * FROM few f1, 44 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id DESC; 47 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id, g DESC; 51 SELECT few.id FROM few ORDER BY id, generate_series(1,3) DESC; 55 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 57 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 58 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 66 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa ORDER BY 2; 67 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa, unnest('{1,1,3}'::int[]) … 91 SELECT few.dataa, count(*), min(id), max(id), generate_series(1,3) FROM few GROUP BY few.dataa ORDE… [all …]
|
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/ |
H A D | tsrf.sql | 62 few 69 few 107 few 116 few 125 few 134 few 150 few 164 few 178 few 193 few [all …]
|
/dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/ |
H A D | tsrf.sql | 38 SELECT * FROM few f1, 44 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id DESC; 47 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id, g DESC; 51 SELECT few.id FROM few ORDER BY id, generate_series(1,3) DESC; 55 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 57 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 58 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 66 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa ORDER BY 2; 67 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa, unnest('{1,1,3}'::int[]) … 91 SELECT few.dataa, count(*), min(id), max(id), generate_series(1,3) FROM few GROUP BY few.dataa ORDE… [all …]
|
/dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/ |
H A D | tsrf.sql | 38 SELECT * FROM few f1, 44 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id DESC; 47 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id, g DESC; 51 SELECT few.id FROM few ORDER BY id, generate_series(1,3) DESC; 55 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 57 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 58 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 66 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa ORDER BY 2; 67 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa, unnest('{1,1,3}'::int[]) … 91 SELECT few.dataa, count(*), min(id), max(id), generate_series(1,3) FROM few GROUP BY few.dataa ORDE… [all …]
|
/dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/ |
H A D | tsrf.sql | 38 SELECT * FROM few f1, 44 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id DESC; 47 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id, g DESC; 51 SELECT few.id FROM few ORDER BY id, generate_series(1,3) DESC; 55 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 57 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 58 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 66 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa ORDER BY 2; 67 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa, unnest('{1,1,3}'::int[]) … 91 SELECT few.dataa, count(*), min(id), max(id), generate_series(1,3) FROM few GROUP BY few.dataa ORDE… [all …]
|
/dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/ |
H A D | tsrf.sql | 38 SELECT * FROM few f1, 44 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id DESC; 47 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id, g DESC; 51 SELECT few.id FROM few ORDER BY id, generate_series(1,3) DESC; 55 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 57 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 58 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 66 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa ORDER BY 2; 67 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa, unnest('{1,1,3}'::int[]) … 91 SELECT few.dataa, count(*), min(id), max(id), generate_series(1,3) FROM few GROUP BY few.dataa ORDE… [all …]
|
/dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/ |
H A D | tsrf.sql | 38 SELECT * FROM few f1, 44 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id DESC; 47 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id, g DESC; 51 SELECT few.id FROM few ORDER BY id, generate_series(1,3) DESC; 55 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 57 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 58 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 66 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa ORDER BY 2; 67 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa, unnest('{1,1,3}'::int[]) … 91 SELECT few.dataa, count(*), min(id), max(id), generate_series(1,3) FROM few GROUP BY few.dataa ORDE… [all …]
|
/dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/ |
H A D | tsrf.sql | 38 SELECT * FROM few f1, 44 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id DESC; 47 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id, g DESC; 51 SELECT few.id FROM few ORDER BY id, generate_series(1,3) DESC; 55 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 57 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 58 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 66 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa ORDER BY 2; 67 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa, unnest('{1,1,3}'::int[]) … 91 SELECT few.dataa, count(*), min(id), max(id), generate_series(1,3) FROM few GROUP BY few.dataa ORDE… [all …]
|
/dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/ |
H A D | tsrf.sql | 38 SELECT * FROM few f1, 44 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id DESC; 47 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id, g DESC; 51 SELECT few.id FROM few ORDER BY id, generate_series(1,3) DESC; 55 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 57 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 58 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 66 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa ORDER BY 2; 67 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa, unnest('{1,1,3}'::int[]) … 91 SELECT few.dataa, count(*), min(id), max(id), generate_series(1,3) FROM few GROUP BY few.dataa ORDE… [all …]
|
/dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/ |
H A D | tsrf.sql | 38 SELECT * FROM few f1, 44 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id DESC; 47 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id, g DESC; 51 SELECT few.id FROM few ORDER BY id, generate_series(1,3) DESC; 55 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 57 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 58 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 66 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa ORDER BY 2; 67 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa, unnest('{1,1,3}'::int[]) … 91 SELECT few.dataa, count(*), min(id), max(id), generate_series(1,3) FROM few GROUP BY few.dataa ORDE… [all …]
|
/dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/ |
H A D | tsrf.sql | 38 SELECT * FROM few f1, 44 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id DESC; 47 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id, g DESC; 51 SELECT few.id FROM few ORDER BY id, generate_series(1,3) DESC; 55 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 57 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 58 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 66 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa ORDER BY 2; 67 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa, unnest('{1,1,3}'::int[]) … 91 SELECT few.dataa, count(*), min(id), max(id), generate_series(1,3) FROM few GROUP BY few.dataa ORDE… [all …]
|
/dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/sql/ |
H A D | tsrf.sql | 38 SELECT * FROM few f1, 44 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id DESC; 47 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id, g DESC; 51 SELECT few.id FROM few ORDER BY id, generate_series(1,3) DESC; 55 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 57 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 58 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 66 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa ORDER BY 2; 67 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa, unnest('{1,1,3}'::int[]) … 91 SELECT few.dataa, count(*), min(id), max(id), generate_series(1,3) FROM few GROUP BY few.dataa ORDE… [all …]
|
/dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/sql/ |
H A D | tsrf.sql | 38 SELECT * FROM few f1, 44 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id DESC; 47 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id, g DESC; 51 SELECT few.id FROM few ORDER BY id, generate_series(1,3) DESC; 55 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 57 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 58 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 66 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa ORDER BY 2; 67 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa, unnest('{1,1,3}'::int[]) … 91 SELECT few.dataa, count(*), min(id), max(id), generate_series(1,3) FROM few GROUP BY few.dataa ORDE… [all …]
|
/dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/sql/ |
H A D | tsrf.sql | 38 SELECT * FROM few f1, 44 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id DESC; 47 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id, g DESC; 51 SELECT few.id FROM few ORDER BY id, generate_series(1,3) DESC; 55 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 57 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 58 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 66 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa ORDER BY 2; 67 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa, unnest('{1,1,3}'::int[]) … 91 SELECT few.dataa, count(*), min(id), max(id), generate_series(1,3) FROM few GROUP BY few.dataa ORDE… [all …]
|
/dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/sql/ |
H A D | tsrf.sql | 38 SELECT * FROM few f1, 44 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id DESC; 47 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id, g DESC; 51 SELECT few.id FROM few ORDER BY id, generate_series(1,3) DESC; 55 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 57 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 58 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 66 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa ORDER BY 2; 67 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa, unnest('{1,1,3}'::int[]) … 91 SELECT few.dataa, count(*), min(id), max(id), generate_series(1,3) FROM few GROUP BY few.dataa ORDE… [all …]
|
/dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/ |
H A D | tsrf.sql | 38 SELECT * FROM few f1, 44 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id DESC; 47 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id, g DESC; 51 SELECT few.id FROM few ORDER BY id, generate_series(1,3) DESC; 55 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 57 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 58 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 66 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa ORDER BY 2; 67 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa, unnest('{1,1,3}'::int[]) … 91 SELECT few.dataa, count(*), min(id), max(id), generate_series(1,3) FROM few GROUP BY few.dataa ORDE… [all …]
|
/dports/databases/postgresql11-server/postgresql-11.14/src/test/regress/sql/ |
H A D | tsrf.sql | 38 SELECT * FROM few f1, 44 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id DESC; 47 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id, g DESC; 51 SELECT few.id FROM few ORDER BY id, generate_series(1,3) DESC; 55 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 57 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 58 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 66 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa ORDER BY 2; 67 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa, unnest('{1,1,3}'::int[]) … 91 SELECT few.dataa, count(*), min(id), max(id), generate_series(1,3) FROM few GROUP BY few.dataa ORDE… [all …]
|
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/ |
H A D | tsrf.sql | 38 SELECT * FROM few f1, 44 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id DESC; 47 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id, g DESC; 51 SELECT few.id FROM few ORDER BY id, generate_series(1,3) DESC; 55 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 57 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 58 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 66 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa ORDER BY 2; 67 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa, unnest('{1,1,3}'::int[]) … 91 SELECT few.dataa, count(*), min(id), max(id), generate_series(1,3) FROM few GROUP BY few.dataa ORDE… [all …]
|
/dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/ |
H A D | tsrf.sql | 38 SELECT * FROM few f1, 44 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id DESC; 47 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id, g DESC; 51 SELECT few.id FROM few ORDER BY id, generate_series(1,3) DESC; 55 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 57 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 58 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 66 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa ORDER BY 2; 67 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa, unnest('{1,1,3}'::int[]) … 91 SELECT few.dataa, count(*), min(id), max(id), generate_series(1,3) FROM few GROUP BY few.dataa ORDE… [all …]
|
/dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/sql/ |
H A D | tsrf.sql | 38 SELECT * FROM few f1, 44 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id DESC; 47 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id, g DESC; 51 SELECT few.id FROM few ORDER BY id, generate_series(1,3) DESC; 55 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 57 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 58 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 66 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa ORDER BY 2; 67 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa, unnest('{1,1,3}'::int[]) … 91 SELECT few.dataa, count(*), min(id), max(id), generate_series(1,3) FROM few GROUP BY few.dataa ORDE… [all …]
|
/dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/sql/ |
H A D | tsrf.sql | 38 SELECT * FROM few f1, 44 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id DESC; 47 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id, g DESC; 51 SELECT few.id FROM few ORDER BY id, generate_series(1,3) DESC; 55 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 57 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 58 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 66 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa ORDER BY 2; 67 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa, unnest('{1,1,3}'::int[]) … 91 SELECT few.dataa, count(*), min(id), max(id), generate_series(1,3) FROM few GROUP BY few.dataa ORDE… [all …]
|
/dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/ |
H A D | tsrf.sql | 38 SELECT * FROM few f1, 44 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id DESC; 47 SELECT few.id, generate_series(1,3) g FROM few ORDER BY id, g DESC; 51 SELECT few.id FROM few ORDER BY id, generate_series(1,3) DESC; 55 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 57 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 58 SELECT few.dataa, count(*), min(id), max(id), unnest('{1,1,3}'::int[]) FROM few WHERE few.id = 1 GR… 66 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa ORDER BY 2; 67 SELECT few.dataa, count(*) FROM few WHERE dataa = 'a' GROUP BY few.dataa, unnest('{1,1,3}'::int[]) … 91 SELECT few.dataa, count(*), min(id), max(id), generate_series(1,3) FROM few GROUP BY few.dataa ORDE… [all …]
|