postgreSQL generate_series in v9.6 vs 12.8

Ignition
9

Try this:

SELECT a.datum, a.izmena, energijakosipoizmenah_new.dobri, energijakosipoizmenah_new.slabi, energijakosipoizmenah_new.porabaelektrike, energijakosipoizmenah_new.porabazraka
FROM (
	SELECT b.generate_series datum,
		c.generate_series izmena
	FROM generate_series('2021-05-10'::date, '2021-05-17'::date,'1 day') b,
		generate_series(1, 3) c
) a
LEFT OUTER JOIN energijakosipoizmenah_new ON a.datum = date(energijakosipoizmenah_new.datum) AND a.izmena = energijakosipoizmenah_new.izmena;
1 Like