Tim Uckun <timuckun@xxxxxxxxx> writes: > 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. FWIW, I just tried it on mysql 5.5.2, and got results similar to Postgres: the limit/offset are considered to apply to the single aggregated row, not the aggregate's input rows as that library seems to be expecting. I wonder what database they were using for testing ... regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
