PgsqlSqlHelper::getTopSql

public function getTopSql($sql, $limit, $offset = 0)
{
	$offset = intval($offset);
	$limit = intval($limit);

	if ($offset > 0 && $limit <= 0)
	{
		throw new BitrixMainArgumentException("Limit must be set if offset is set");
	}

	if ($limit > 0)
	{
		$sql .= "nLIMIT ".$limit;
	}

	if ($offset > 0)
	{
		$sql .= " OFFSET ".$offset;
	}

	$sql .= "n";

	return $sql;
}