returns numbers of record

From: "Enrico Pirozzi" <sscotty71(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: returns numbers of record
Date: 2008-12-02 22:22:05
Message-ID: 5d038c780812021422o5d70bc3fpa764857807c7163c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-12-02 23:15:19 Re: Corruption in postgres 7.4 on solaris 2.9.
Previous Message Gary Schlachter 2008-12-02 21:46:53 Corruption in postgres 7.4 on solaris 2.9.