title: How to show row numbers in PostgreSQL query?
body: <p>I'd like to show the observation number for each record returned by a PostgreSQL query.</p>
  
  <p>I think in 8.4 windowing functions can perform this capability.</p>