On Fri, Aug 5, 2011 at 4:51 AM, Tim Uckun <timuc...@gmail.com> wrote: > I am using a library which is emitting SQL like this SELECT COUNT(*) > FROM batches LIMIT 15 OFFSET 15 the library fails because on postgres > this query returns nothing (not even zero as a result). Presumably it > returns some valid value on mysql and other databases. > > Other than hacking the library is there anything I can do? > > Oddly enough SELECT count(*) FROM batches LIMIT 15 returns the full > count of the table. Presumably the count has to be done on a subquery > right?
Since select count(*) will return one row, you're limit / offset are in the wrong place. You want something like: select count(*) from (select * from batches ordery by something limit 15 offset 15); -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
