Re: select count(*) and limit

From: Verena Ruff <lists(at)triosolutions(dot)at>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: select count(*) and limit
Date: 2006-05-18 15:00:51
Message-ID: 446C8C23.6040606@triosolutions.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tomeh, Husam 2006-05-18 15:13:58
Previous Message Joe 2006-05-18 14:23:12 Re: MySQL DB to PostgresSQL DB