Hello http://www.postgresql.org/docs/8.2/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS regards Pavel Stehule On 30/01/2008, Eugenio Tacchini <eugenio.tacchini@xxxxxxxx> wrote: > 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. > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings