select
    *
from (
    with 
    tim as 
    (
        select *
        from
            (values
                ('08:00'::interval,'20:00'::interval,1), -- с 8:00 до 20:00
                ('20:00'::interval,'32:00'::interval,2), -- с 20:00 до 8:00
                ('20:00'::interval,'44:00'::interval,3), -- с 20:00 до 20:00
                ('08:00'::interval,'32:00'::interval,4)  -- с 8:00 до 8:00
            ) as cc (first, last, type_int)
        where type_int = any(string_to_array('1,2,3,4', ',')::int4[])
    ),
    tim2 as 
    (
        select 
            ((id)::text || ' day')::interval as id, 
            tim.*
        from generate_series(0, '2014-02-02'::date - '2014-01-15'::date) as some_table (id)
        cross join tim
        order by 1, 2
    )
    select 
        ('2014-01-15'::date+(id + first)) as first_date,
        ('2014-01-15'::date+(id + last)) as last_date
    from tim2
    ) x
where
    x.first_date >= '2014-01-15'::datetime and 
    x.last_date <= '2014-02-02'::date + '23:59:59'::time
order by 1