I would like to extract all the rows from a table until and including
check_type = 'schedule' and checked_at < '2016-09-26', in this situation I don't have a lower bound for
checked_at, the lower bound could be the
checked_at value of the first row which has the type
scheduled, but I don't see how I can get that.
CREATE TABLE project_check_history ( id serial PRIMARY KEY, project_id int4, check_type varchar, checked_at timestamp ); INSERT INTO project_check_history(project_id, check_type, checked_at) VALUES (1, 'instant', '2016-09-26'), (1, 'instant', '2016-09-25'), (1, 'scheduled', '2016-09-24'), (1, 'instant', '2016-09-23'), (1, 'scheduled', '2016-09-23'); (1, 'instant', '2016-09-22'), (1, 'scheduled', '2016-09-21');
This is part of a bigger question here, but I'm really stuck, and don't see how I can do it.
Expected output it will be:
checked_at 2016-09-26 2016-09-25 2016-09-24