psql 9.1 select newest update record among similar record : I have  2 tables segments and summaries.     
I want to list the shows in a date interval and just show the latest updated segments (in bold) since it is the freshest copy of the segment for that person.    
Here is the query I used to have the result below:       
        
    select seg.summ, su.channel, seg.block_id, seg.person, seg.updated_at as segupdate from segments seg left join summaries su on seg.summ = su.id where su.created_at between '2018-06-06' and '2018-07-13' order by summ, block_id, seg.updated_at desc;   
    
[![enter image description here][1]][1]     
    
I want this :    
  
[![enter image description here][2]][2]    
 How can I get change my query to show just the bolded rows? to remove the duplicates that are an older version?


  [1]: https://i.stack.imgur.com/wy70A.png
  [2]: https://i.stack.imgur.com/hBr2Z.png