No I'm looking something else, as I wrote above :) Regards Enrico 2008/12/3 justin <justin@xxxxxxxxxxxxxxx>: > 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 >> >> > > -- That's one small step for man; one giant leap for mankind www.enricopirozzi.info info@xxxxxxxxxxxxxxxxxx Skype sscotty71 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
