Re: returns numbers of record

No I'm looking something else, as I wrote above :)

Regards
Enrico

2008/12/3 justin <justin(at)emproshunts(dot)com>:
> 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(at)enricopirozzi(dot)info
Skype sscotty71