Re: select count(*) and limit - Mailing list pgsql-novice

From Verena Ruff
Subject Re: select count(*) and limit
Date
Msg-id 446C8C23.6040606@triosolutions.at
Whole thread Raw
In response to Re: select count(*) and limit  (John DeSoi <desoi@pgedit.com>)
List pgsql-novice
John DeSoi schrieb:
> A cursor still might be useful, but it would only be used for the
> current request. You could run the query once and fetch the rows you
> want to display from the cursor. Then scan to the end of the cursor to
> find out how many rows it has. The MOVE command does this and returns
> the number of rows.
thanks for this hint. I'll test it.

Regards,
Verena

pgsql-novice by date:

Previous
From: John DeSoi
Date:
Subject: Re: select count(*) and limit
Next
From: "Tomeh, Husam"
Date:
Subject: