title: the limit clause with postgresql
body: <p>how can I transform this mysql limit clause for Postgresql:</p>
  
  <pre><code>limit $a,$b
  </code></pre>
  
  <p>when possible not a specific postgresql solution but rather a sql standard</p>
  
  <p>Query failed: ERREUR:  la syntaxe LIMIT #,# n'est pas supportée</p>
  
  <p><strong>EDITION</strong></p>
  
  <pre><code>"select * from preference where (id_membre ='184') order by 1 LIMIT 0 OFFSET 8";    
  </code></pre>
  
  <p>return 4 rows with mysql, 0 rows with postgresl !</p>