It's been a while since I've done a lot of SQL work so I'm afraid I'm stuck with a query that should be pretty simple . I'm running Postgresql 8.3.3.
I have a table that tracks the execution of a process ("a run"). The table is very simple containing only runid, created_at and updated_at fields. "Runs" can occur at any time and any date. What I'm trying to do is extract the first runid and run date (created_at) of each month for which there are records in the table.