Re: returns numbers of record - Mailing list pgsql-general

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
>
>