Home > mailing lists

Select count with offset returns nothing. - Mailing list pgsql-general

From	Tim Uckun
Subject	Select count with offset returns nothing.
Date	August 5, 2011 07:51:31
Msg-id	CAGuHJrNz+AfJTjEv1fkd2k3uod0XBK9GspnTMJKtDRe125Afxw@mail.gmail.com Whole thread Raw
Responses	Re: Select count with offset returns nothing. Re: Select count with offset returns nothing. Re: Select count with offset returns nothing. Re: Select count with offset returns nothing. Re: Select count with offset returns nothing.
List	pgsql-general

Tree view

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?

pgsql-general by date:

From: Condor
Date: 05 August 2011, 07:49:03
Subject: Postgresql problem with update double precision

From: Misa Simic
Date: 05 August 2011, 08:01:35
Subject: Re: Select count with offset returns nothing.

Select count with offset returns nothing. - Mailing list pgsql-general

Previous

Next