My question is why would you put an offset in a query designed to return a row count without grouping and ordering?
> Date: Fri, 5 Aug 2011 22:51:24 +1200 > Subject: [GENERAL] Select count with offset returns nothing. > From: [email protected] > To: [email protected] > > 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? > > -- > Sent via pgsql-general mailing list ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general
