title: How do I trickle results to the client from PostgreSQL
body: <p>For testing I would like to create a query that trickles results back to the client. </p>
  
  <p>Have it return 1 row, wait a second, return 1 row.  </p>
  
  <p>I tried the trivial change but it failed. (it returns a single chunk)</p>
  
  <pre><code>select pg_sleep(1)
  union all 
  select pg_sleep(1)
  </code></pre>
  
  <p>How can I craft a query that trickles results back? </p>