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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general