php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #23031 limitQuery doesn't work with PostgreSQL
Submitted: 2003-04-03 03:23 UTC Modified: 2003-04-12 10:45 UTC
From: kristof dot nast-kolb at foroso dot de Assigned:
Status: Closed Package: PEAR related
PHP Version: 4.3.2RC1 OS: linux
Private report: No CVE-ID: None
View Developer Edit
 [2003-04-03 03:23 UTC] kristof dot nast-kolb at foroso dot de 
limitQuery must use the OFFSET parameter instead of COUNT offset, count in pgsql. so correct would be:
    function modifyLimitQuery($query, $from, $count)
    {
        $query = $query . " LIMIT $count OFFSET $from";
    }
in DB/pgsql.php
Tested with postgresql 7.2.3

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-04-12 10:45 UTC] alan_k@php.net 
This bug has been fixed in CVS.

In case this was a PHP problem, snapshots of the sources are packaged
every three hours; this change will be in the next snapshot. You can
grab the snapshot at http://snaps.php.net/.
 
In case this was a documentation problem, the fix will show up soon at
http://www.php.net/manual/.

In case this was a PHP.net website problem, the change will show
up on the PHP.net site and on the mirror sites in short time.
 
Thank you for the report, and for helping us make PHP better.
 
PHP Copyright © 2001-2026 The PHP Group
All rights reserved. 		Last updated: Thu Oct 08 10:00:01 2026 UTC