title: How to pass limit and off set values dynamically in native query
body: <p>I'm using native query to fetch the pagination results from PostgreSQL and I used this query and I'm getting the below exception:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT a.*
    FROM table1 a LEFT OUTER JOIN table2 b ON a.clmn1 = b.clmn1
    WHERE (a.clmn3 = ?3 OR a.clmn4 ISNULL)
    ORDER BY a.clmn1 DESC offset = ?1 limit = ?2
  </code></pre>
  
  <p>Query:</p>
  
  <pre><code>@Query(nativeQuery = true, value="select a.* from table1 a left outer join table2 b ON a.clmn1 = b.clmn1 where (a.clmn3= ?3 OR a.clmn4 isnull) order by a.clmn1 desc offset = ?1 limit = ?2")
  public List&lt;Result&gt; getResults(int offset, int limit, int value);
  </code></pre>
  
  <p>Exception:</p>
  
  <pre><code>org.postgresql.util.PSQLException: ERROR: syntax error at or near "="
  </code></pre>
  
  <p>Please suggest.</p>