clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3364508 fiddles created (36230 in the last week).

with days as ( select dd, extract(DOW from dd) dw from generate_series('2017-04-28'::date, '2017-05-02'::date, '1 day'::interval) dd ) select * from days where dw not in (6,0);
dd dw
2017-04-28 00:00:00+00 5
2017-05-01 00:00:00+00 1
2017-05-02 00:00:00+00 2
SELECT 3
 hidden batch(es)