title: Get the row with max(timestamp)
body: <p>I need to select most recently commented articles, with the last comment for each article, i.e. other columns of the row which contains <code>max(c.created)</code>:</p>
  
  <pre><code>SELECT a.id, a.title, a.text, max(c.created) AS cid, c.text?
  FROM subscriptions s
  JOIN articles a ON a.id=s.article_id
  JOIN comments c ON c.article_id=a.id
  WHERE s.user_id=%d
  GROUP BY a.id, a.title, a.text
  ORDER BY max(c.created) DESC LIMIT 10;
  </code></pre>
  
  <p>Postgres tells me that I have to put c.text into GROUP BY. Obviously, I don't want to do this. min/max doesn't fit too. I don't have idea, how to select this.</p>
  
  <p>Please advice.</p>