DB_Dataobjects::find() and Postgres 7.3 problem
| From: | Hans Westerbeek | Date: | Thu, 17 Apr 2003 11:08:40 +0000 |
| Subject: | DB_Dataobjects::find() and Postgres 7.3 problem | ||
| Groups: | php.pear.dev | ||
| Request: | Send a blank email to pear-dev+get-15214@lists.php.net to get a copy of this message | ||
Hi,
As of version 7.3, PostgreSQL requires that the LIMIT clause is used like this:
SELECT * FROM headlines LIMIT 10 OFFSET 0;
(returning the first 10 records in the table)
DB_Dataobjects still uses LIMIT 0, 10, therefore this piece of code fails:
$do =& $this->_getDaObject();
$do->limit(0, 10);
$do->orderBy('id DESC');
$do->find();
I can see how this can be fixed in the limit() method but i'm not sure if that's the right way to go...
Hans