CREATE OR REPLACE VIEW food600.skupstr
 AS
 SELECT skupiny.c_data,
    skupiny.druh::CHARACTER(30),
    skupiny.spart,
    skupiny.spart_kas,
    skupiny.typ_skup,
    skupiny.typ_skl,
    skupiny.typ_kalk,
    skupiny.dan01,
    skupiny.dan02,
    skupiny.dan03,
    skupiny.dan04,
    skupiny.dan05,
    skupiny.dan06,
    skupiny.dan07,
    skupiny.dan08,
    skupiny.dan09,
    skupiny.dan10,
    skupiny.dan11,
    skupiny.dan12,
    skupiny.dan13,
    skupiny.dan14,
    skupiny.dan15,
    skupiny.dan16,
    skupiny.dan17,
    skupiny.dan18,
    skupiny.dan19,
    skupiny.dan20,
    skupiny.dan21,
    skupiny.dan22,
    skupiny.dan23,
    skupiny.dan24,
    skupiny.dan25,
    skupiny.dan26,
    skupiny.dan27,
    skupiny.dan28,
    skupiny.dan29,
    skupiny.dan30,
    skupiny.dan31,
    skupiny.dan32,
    skupiny.dan33,
    skupiny.dan34,
    skupiny.dan35,
    skupiny.dan36,
    skupiny.dan37,
    skupiny.dan38,
    skupiny.dan39,
    skupiny.dan40,
    skupiny.druh1,
    skupiny.druh2,
    skupiny.druh3,
    skupiny.druh4,
    skupiny.druh5,
    skupiny.poradie,
    skupiny.c_druh,
    skupiny.dotacia
   FROM food600.skupiny
  WHERE skupiny.typ_skup <> ''::character(1)
UNION
 SELECT 0 AS c_data,
    ''::character(30) AS druh,
    ''::character(3) AS spart,
    ''::character(3) AS spart_kas,
    'a'::character(1) AS typ_skup,
    ''::character(1) AS typ_skl,
    ''::character(1) AS typ_kalk,
    0.00 AS dan01,
    0.00 AS dan02,
    0.00 AS dan03,
    0.00 AS dan04,
    0.00 AS dan05,
    0.00 AS dan06,
    0.00 AS dan07,
    0.00 AS dan08,
    0.00 AS dan09,
    0.00 AS dan10,
    0.00 AS dan11,
    0.00 AS dan12,
    0.00 AS dan13,
    0.00 AS dan14,
    0.00 AS dan15,
    0.00 AS dan16,
    0.00 AS dan17,
    0.00 AS dan18,
    0.00 AS dan19,
    0.00 AS dan20,
    0.00 AS dan21,
    0.00 AS dan22,
    0.00 AS dan23,
    0.00 AS dan24,
    0.00 AS dan25,
    0.00 AS dan26,
    0.00 AS dan27,
    0.00 AS dan28,
    0.00 AS dan29,
    0.00 AS dan30,
    0.00 AS dan31,
    0.00 AS dan32,
    0.00 AS dan33,
    0.00 AS dan34,
    0.00 AS dan35,
    0.00 AS dan36,
    0.00 AS dan37,
    0.00 AS dan38,
    0.00 AS dan39,
    0.00 AS dan40,
    ''::character(30) AS druh1,
    ''::character(30) AS druh2,
    ''::character(30) AS druh3,
    ''::character(30) AS druh4,
    ''::character(30) AS druh5,
    0 AS poradie,
    0 AS c_druh,
    0::smallint AS dotacia
   FROM food600.skupiny;
