Re: returns numbers of record

From: Richard Huxton <dev(at)archonet(dot)com>
To: info(at)enricopirozzi(dot)info
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: returns numbers of record
Date: 2008-12-03 11:31:23
Message-ID: 49366E0B.1010302@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Enrico Pirozzi wrote:
> Hi all,
> does it exists a way to know how many records a query returns?

Not without fetching the rows. If you're not using a cursor then all the
rows will be fetched anyway and whatever library you're using will
almost certainly have a pg_numrows() function or some such.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gary Schlachter 2008-12-03 13:25:37 Re: Corruption in postgres 7.4 on solaris 2.9.
Previous Message Magnus Hagander 2008-12-03 10:25:14 Re: concurrent users