On Tue, Jul 31, 2007 at 07:24:34AM +0100, Oliver Elphick wrote:
> BEGIN;
> SELECT * FROM mytable OFFSET X LIMIT Y;
> SELECT COUNT(*) AS total FROM mytable;
> END;
>
> (To ensure consistent results, both queries should be done in a single
> transaction.)
To ensure consistent results the transaction should be SERIALIZABLE.
With the default of READ COMMITTED changes between the two selects
would be visible to the second select.
--
Michael Fuhr