<commit_before>package ca.krasnay.sqlbuilder;

/**
 * Dialect for PostgreSQL.
 *
 * @author <NAME> <<EMAIL>>
 */
public class PostgresqlDialect implements Dialect {

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

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

}<commit_msg>Fix SQL syntax in PostgresqlDialect<commit_after>package ca.krasnay.sqlbuilder;

/**
 * Dialect for PostgreSQL.
 *
 * @author <NAME> <<EMAIL>>
 */
public class PostgresqlDialect implements Dialect {

    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);
    }

}
{'fraction_non_alphanumeric': 0.12747252747252746, 'fraction_numerical': 0.0, 'mean_word_length': 3.465686274509804, 'pattern_counts': {'":': 0, '<': 9, '<?xml version=': 0, '>': 9, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5626473', 'n_tokens_mistral': 287, 'n_tokens_neox': 281, 'n_words': 83}