Home
last modified time | relevance | path

Searched refs:few (Results 1 – 25 of 10955) sorted by relevance

12345678910>>...439

/dports/science/quantum-espresso/q-e-qe-6.7.0/EPW/examples/diamond/phonons/Ref/
H A Dph.out56 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 Dal.ph.disp.collect.out209 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 Dal.ph.collect.out218 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 Dtsrf.sql38 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 Dtsrf.sql62 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 Dtsrf.sql38 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 Dtsrf.sql38 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 Dtsrf.sql38 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 Dtsrf.sql38 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 Dtsrf.sql38 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 Dtsrf.sql38 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 Dtsrf.sql38 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 Dtsrf.sql38 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 Dtsrf.sql38 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 Dtsrf.sql38 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 Dtsrf.sql38 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 Dtsrf.sql38 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 Dtsrf.sql38 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 Dtsrf.sql38 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 Dtsrf.sql38 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 Dtsrf.sql38 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 Dtsrf.sql38 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 Dtsrf.sql38 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 Dtsrf.sql38 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 Dtsrf.sql38 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 …]

12345678910>>...439