Get the number of records of a result set

From: Eugenio Tacchini <eugenio(dot)tacchini(at)elfo(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Get the number of records of a result set
Date: 2008-01-30 08:14:05
Message-ID: 20080130081405.CF1331D34BE@smtp.eutelia.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
I'm writing a function in PL/pgSQL and I would like to know if there
is a method to get the number of records in a result set, after a
select query, without executing the same query using COUNT(*).

Thanks.

Regards,

Eugenio.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2008-01-30 08:33:42 Re: Get the number of records of a result set
Previous Message Ow Mun Heng 2008-01-30 07:54:02 Re: postgresql book - practical or something newer?