Re: count(*) and bad design was: Experiences with extensibility - Mailing list pgsql-general

From Ivan Sergio Borgonovo
Subject Re: count(*) and bad design was: Experiences with extensibility
Date
Msg-id 20080115150311.4fad06fe@webthatworks.it
Whole thread Raw
In response to Re: count(*) and bad design was: Experiences with extensibility  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
Responses Re: count(*) and bad design was: Experiences with extensibility
List pgsql-general
On Tue, 15 Jan 2008 14:43:35 +0100
Alban Hertroys <dalroi@solfertje.student.utwente.nl> wrote:

> You need to scroll to the last row to find the size of the result
> set, but after that it's pretty easy to return random rows by
> scrolling to them (and marking them 'read' in some way to prevent
> accidentally returning the same row again).

Could you post a snippet of code or something giving a more detailed
idea of it?

BTW since cursors support offset if you're not interested if the
order of the retrieved rows is random too you don't even have to
remember which one you read I think.

--
Ivan Sergio Borgonovo
http://www.webthatworks.it


pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Postgres installation on Leopard; database on Mac-User-Level
Next
From: Richard Huxton
Date:
Subject: Re: Forgot to dump old data before re-installing machine