Select Count(*) from (query) is what i believe you are looking for see
http://www.postgresql.org/docs/8.3/interactive/tutorial-agg.html
Enrico Pirozzi wrote:
Hi all,
does it exists a way to know how many records a query returns?
I thought sometime like
DECLARE curs1 CURSOR FOR select * from table ;
I thought if I can write MOVE LAST Is there any way to return
the number of row for select * from table without execute a count(*) ?
Thanks :)
Enrico
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
