On Tue, Jul 31, 2007 at 07:24:34AM +0100, Oliver Elphick wrote:
> SELECT * FROM mytable OFFSET X LIMIT Y;
> SELECT COUNT(*) AS total FROM mytable;
> (To ensure consistent results, both queries should be done in a single
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.
In response to
pgsql-novice by date
|Next:||From: Paul Malherbe||Date: 2007-08-01 12:33:56|
|Subject: Querying multiple tables|
|Previous:||From: Oliver Elphick||Date: 2007-07-31 10:20:31|
|Subject: Re: tsearch2.sql and different versions of PostgreSQL|