Fwd: [PEAR] DB / pgsql.php LIMIT clause problem

Forwarding to pear-dev. Matt: may be good to fill a bug report so there is a record of the changes in the bugs db too. --- Matt Haught <haughtlists@hotmail.com> wrote: > From: "Matt Haught" <haughtlists@hotmail.com> > To: <pear-general@lists.php.net> > Date: Sat, 4 Jan 2003 19:54:30 -0500 > Subject: [PEAR] DB / pgsql.php LIMIT clause problem > > On line 559 of pgsql.php, it should read > $query = $query . " LIMIT $count OFFSET $from"; > > The reason for this is that the old "LIMIT $count, $from" does not work with > version 7.3.1 of postgresql any longer. I don't believe there is a problem > with using it with the older versions as I believe that they also support > the OFFSET clause. Note that I have only tested it with 7.3.1 (nice > surprise after I upgraded, I guess I should have read the release notes > closer). If there are no problems with older versions, maybe we could have > it changed or have a workaround :) Thanks, > > -- > Matt Haught > > -- > PEAR General Mailing List (http://pear.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > ===== --- Jesus M. Castagnetto (jcastagnetto@yahoo.com) Research: http://metallo.scripps.edu/ Personal: http://www.castagnetto.org/ __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com