You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
49 lines
1.6 KiB
49 lines
1.6 KiB
SET
|
|
CREATE TABLE
|
|
INSERT 0 1114
|
|
CREATE TABLE
|
|
INSERT 0 1114
|
|
CREATE TABLE
|
|
INSERT 0 5
|
|
SELECT 1114
|
|
|
|
|
|
|
|
{_vovw_2_base_bare_t,_vovw_1_base_bare_t,_vovw_0_base_bare_t}
|
|
126
|
|
number,int_number,name,start
|
|
SUM(number*1)/count(*)::double precision AS number,SUM(int_number*1)/count(*)::integer AS int_number,CASE WHEN count(distinct name) = 1 THEN MIN(name) WHEN count(*) < 5 THEN string_agg(distinct name,' / ') ELSE '*' END::text AS name,CASE count(*) WHEN 1 THEN MIN(start) ELSE NULL END::date AS start
|
|
SUM(tab.number*1)/count(*)::double precision AS number,SUM(tab.int_number*1)/count(*)::integer AS int_number,CASE WHEN count(distinct tab.name) = 1 THEN MIN(tab.name) WHEN count(*) < 5 THEN string_agg(distinct tab.name,' / ') ELSE '*' END::text AS name,CASE count(*) WHEN 1 THEN MIN(tab.start) ELSE NULL END::date AS start
|
|
{_vovw_2_base_t,_vovw_1_base_t,_vovw_0_base_t}
|
|
126
|
|
|
|
{_vovw_2_column_types_t,_vovw_1_column_types_t,_vovw_0_column_types_t}
|
|
(base_t,0,_vovw_0_base_t)
|
|
(base_t,1,_vovw_1_base_t)
|
|
(base_t,2,_vovw_2_base_t)
|
|
(base_t,0,_vovw_0_base_t)
|
|
(base_t,1,_vovw_1_base_t)
|
|
(base_t,2,_vovw_2_base_t)
|
|
(base_bare_t,0,_vovw_0_base_bare_t)
|
|
(base_bare_t,1,_vovw_1_base_bare_t)
|
|
(base_bare_t,2,_vovw_2_base_bare_t)
|
|
(base_t,0,_vovw_0_base_t)
|
|
(base_t,1,_vovw_1_base_t)
|
|
(base_t,2,_vovw_2_base_t)
|
|
(column_types_t,0,_vovw_0_column_types_t)
|
|
(column_types_t,1,_vovw_1_column_types_t)
|
|
(column_types_t,2,_vovw_2_column_types_t)
|
|
|
|
|
|
|
|
ERROR: relation "_vovw_2_base_t" does not exist
|
|
LINE 1: SELECT count(*) FROM _vovw_2_base_t;
|
|
^
|
|
{_vovw_5_base_t,_vovw_4_base_t,_vovw_3_base_t,_vovw_2_base_t,_vovw_1_base_t,_vovw_0_base_t}
|
|
38
|
|
|
|
DROP TABLE
|
|
DROP TABLE
|
|
DROP TABLE
|
|
DROP TABLE
|