dataa (reference) in projects: dports - OpenGrok search results

Project(s)

Full Search
Definition
Symbol
File Path
History
Type

Searched refs:dataa (Results 1 – 25 of 498) sorted by relevance

12 3 4 5 6 7 8 9 10 >>...20

/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/
H A D	tsrf.sql	55 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… 95 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab); 96 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 97 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 98 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g); 99 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g) ORD… [all …]
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/
H A D	tsrf.sql	`47 dataa text, field 189 dataa, 200 dataa, 315 dataa, 326 dataa, 336 dataa; 339 dataa, 352 dataa, 364 dataa, 375 dataa; [all …]`
/dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/
H A D	tsrf.sql	55 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… 95 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab); 96 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 97 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 98 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g); 99 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g) ORD… [all …]
/dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/
H A D	tsrf.sql	55 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… 95 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab); 96 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 97 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 98 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g); 99 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g) ORD… [all …]
/dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/
H A D	tsrf.sql	55 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… 95 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab); 96 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 97 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 98 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g); 99 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g) ORD… [all …]
/dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/
H A D	tsrf.sql	55 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… 95 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab); 96 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 97 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 98 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g); 99 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g) ORD… [all …]
/dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/
H A D	tsrf.sql	55 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… 95 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab); 96 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 97 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 98 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g); 99 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g) ORD… [all …]
/dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/
H A D	tsrf.sql	55 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… 95 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab); 96 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 97 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 98 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g); 99 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g) ORD… [all …]
/dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/
H A D	tsrf.sql	55 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… 95 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab); 96 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 97 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 98 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g); 99 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g) ORD… [all …]
/dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/
H A D	tsrf.sql	55 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… 95 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab); 96 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 97 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 98 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g); 99 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g) ORD… [all …]
/dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/
H A D	tsrf.sql	55 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… 95 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab); 96 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 97 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 98 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g); 99 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g) ORD… [all …]
/dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/sql/
H A D	tsrf.sql	55 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… 95 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab); 96 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 97 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 98 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g); 99 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g) ORD… [all …]
/dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/sql/
H A D	tsrf.sql	55 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… 95 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab); 96 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 97 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 98 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g); 99 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g) ORD… [all …]
/dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/sql/
H A D	tsrf.sql	55 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… 95 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab); 96 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 97 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 98 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g); 99 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g) ORD… [all …]
/dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/sql/
H A D	tsrf.sql	55 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… 95 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab); 96 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 97 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 98 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g); 99 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g) ORD… [all …]
/dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/
H A D	tsrf.sql	55 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… 95 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab); 96 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 97 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 98 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g); 99 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g) ORD… [all …]
/dports/databases/postgresql11-server/postgresql-11.14/src/test/regress/sql/
H A D	tsrf.sql	55 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… 95 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab); 96 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 97 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 98 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g); 99 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g) ORD… [all …]
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/
H A D	tsrf.sql	55 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… 95 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab); 96 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 97 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 98 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g); 99 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g) ORD… [all …]
/dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/
H A D	tsrf.sql	55 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… 95 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab); 96 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 97 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 98 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g); 99 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g) ORD… [all …]
/dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/sql/
H A D	tsrf.sql	55 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… 95 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab); 96 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 97 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 98 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g); 99 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g) ORD… [all …]
/dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/sql/
H A D	tsrf.sql	55 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… 95 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab); 96 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 97 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 98 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g); 99 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g) ORD… [all …]
/dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/
H A D	tsrf.sql	55 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… 95 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab); 96 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 97 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 98 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g); 99 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g) ORD… [all …]
/dports/databases/postgresql13-pltcl/postgresql-13.5/src/test/regress/sql/
H A D	tsrf.sql	55 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… 95 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab); 96 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 97 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 98 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g); 99 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g) ORD… [all …]
/dports/databases/postgresql13-server/postgresql-13.5/src/test/regress/sql/
H A D	tsrf.sql	55 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… 95 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab); 96 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 97 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 98 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g); 99 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g) ORD… [all …]
/dports/databases/postgresql13-plpython/postgresql-13.5/src/test/regress/sql/
H A D	tsrf.sql	55 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… 95 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab); 96 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 97 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab) ORDER … 98 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g); 99 SELECT dataa, datab b, generate_series(1,2) g, count() FROM few GROUP BY CUBE(dataa, datab, g) ORD… [all …]

12 3 4 5 6 7 8 9 10 >>...20