ca.krasnay.sqlbuilder.PostgresqlDialect Maven / Gradle / Ivy

Go to download

package ca.krasnay.sqlbuilder;

import java.io.Serializable;

/**
 * Dialect for PostgreSQL.
 *
 * @author John Krasnay 
 */
public class PostgresqlDialect implements Dialect, Serializable {

    private static final long serialVersionUID = 1;

    public String createCountSelect(String sql) {
        return "select count(*) from (" + sql + ") a";
    }

    public String createPageSelect(String sql, int limit, int offset) {
        return String.format("%s limit %d offset %d", sql, limit, offset);
    }

}