Timeseries query in Postgres

query.sql

CREATE OR REPLACE VIEW opendiscrepencydailycounts AS 
 WITH opendays(day) AS ( 
         SELECT gs.day::date AS day 
           FROM generate_series((( SELECT 
min(discrepencylist.discstartdt) AS min 
                   FROM discrepencylist))::timestamp without time 
zone, 'now'::text::date::timestamp without time zone, '1 
day'::interval) gs(day) 
        ) 
 SELECT opendays.day, ds.resolvingparty, count(opendays.day) AS 
opendiscrepancies 
   FROM discrepencylist ds, opendays 
  WHERE opendays.day >= ds.discstartdt AND opendays.day <= 
LEAST('now'::text::date, ds.resolutiondate) 
  GROUP BY opendays.day, ds.resolvingparty 
  ORDER BY opendays.day, ds.resolvingparty;