PostgreSQLJdbcQueryIterator.java

package com.revolsys.gis.postgresql;

import java.util.Map;

import com.revolsys.jdbc.io.JdbcQueryIterator;
import com.revolsys.jdbc.io.JdbcRecordStore;
import com.revolsys.record.query.Query;

public class PostgreSQLJdbcQueryIterator extends JdbcQueryIterator {

  public PostgreSQLJdbcQueryIterator(final JdbcRecordStore recordStore, final Query query,
    final Map<String, Object> properties) {
    super(recordStore, query, properties);
  }

  @Override
  protected String getSql(final Query query) {
    String sql = super.getSql(query);
    final int offset = query.getOffset();
    final int limit = query.getLimit();
    if (offset > 0) {
      sql += " OFFSET " + offset;
    }
    if (limit != Integer.MAX_VALUE) {
      sql += " LIMIT " + limit;
    }
    return sql;
  }

}