Something

public text v1 · immutable

#55410

·published 2006-05-12 16:50 UTC

SELECT date_seq FROM (select '2006-05-08'::date + i as date_seq from generate_series(0,6) s(i)) s1 LEFT JOIN schedules ON (air_date = date_seq ) LEFT JOIN programs ON (programs.database_key = schedules.database_key) WHERE programs.title = $$'Allo, 'Allo$$;
  date_seq  
------------
 2006-05-11
 2006-05-11
 2006-05-11
 2006-05-11
 2006-05-11
 2006-05-11
 2006-05-11
 2006-05-11
 2006-05-11
 2006-05-11
 2006-05-11
 2006-05-12
 2006-05-12
 2006-05-12
 2006-05-13
 2006-05-13
 2006-05-13
 2006-05-14
 2006-05-14
 2006-05-14
 2006-05-14
 2006-05-14
 2006-05-14
 2006-05-14
 2006-05-14
 2006-05-14
 2006-05-14
 2006-05-14
 2006-05-14
 2006-05-14
 2006-05-14
 2006-05-14
 2006-05-14
 2006-05-14
 2006-05-14
 2006-05-14
 2006-05-14
 2006-05-14
 2006-05-14
 2006-05-14
 2006-05-14
 2006-05-14
 2006-05-14
 2006-05-14
(44 rows)