public function DatabaseConnection_pgsql::queryRange
public DatabaseConnection_pgsql::queryRange($query, $from, $count, array $args = array(), array $options = array())
Runs a limited-range query on this database object.
Use this as a substitute for ->query() when a subset of the query is to be returned. User-supplied arguments to the query should be passed in as separate parameters so that they can be properly escaped to avoid SQL injection attacks.
Parameters
$query: A string containing an SQL query.
$args: An array of values to substitute into the query at placeholder markers.
$from: The first result row to return.
$count: The maximum number of result rows to return.
$options: An array of options on the query.
Return value
DatabaseStatementInterface A database query result resource, or NULL if the query was not executed correctly.
Overrides DatabaseConnection::queryRange
File
- includes/database/pgsql/database.inc, line 143
- Database interface code for PostgreSQL database servers.
Class
Code
public function queryRange($query, $from, $count, array $args = array(), array $options = array()) { return $this->query($query . ' LIMIT ' . (int) $count . ' OFFSET ' . (int) $from, $args, $options); }
© 2001–2016 by the original authors
Licensed under the GNU General Public License, version 2 and later.
Drupal is a registered trademark of Dries Buytaert.
https://api.drupal.org/api/drupal/includes!database!pgsql!database.inc/function/DatabaseConnection_pgsql::queryRange/7.x