Documentation TYPO3 par Ameos |
Public Member Functions | |
ADODB_postgres7 () | |
& | SelectLimit ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0) |
MetaForeignKeys ($table, $owner=false, $upper=false) | |
_query ($sql, $inputarr) | |
GetCharSet () | |
SetCharSet ($charset_name) | |
Public Attributes | |
$databaseType = 'postgres7' | |
$hasLimit = true | |
support mssql/access SELECT TOP 10 * FROM TABLE | |
$ansiOuter = true | |
operator to use for right outer join in WHERE clause | |
$charSet = true | |
string to use to quote identifiers and names |
Definition at line 19 of file adodb-postgres7.inc.php.
|
Reimplemented from ADOConnection. Definition at line 60 of file adodb-postgres7.inc.php. References ADODB_postgres64::$rs, and ADOConnection::Execute(). |
|
Will select, getting rows from $offset (1-based), for $nrows. This simulates the MySQL "select * from table limit $offset,$nrows" , and the PostgreSQL "select * from table limit $nrows offset $offset". Note that MySQL and PostgreSQL parameter ordering is the opposite of the other. eg. SelectLimit('select * from table',3); will return rows 1 to 3 (1-based) SelectLimit('select * from table',3,2); will return rows 3 to 5 (1-based) Uses SELECT TOP for Microsoft databases (when $this->hasTop is set) BUG: Currently SelectLimit fails with $sql with LIMIT or TOP clause already set
Reimplemented from ADOConnection. Definition at line 37 of file adodb-postgres7.inc.php. References ADODB_postgres64::$rs, ADOConnection::CacheExecute(), and ADOConnection::Execute(). |