Re: Number of rows in a cursor ? - Mailing list pgsql-sql

From Bo Lorentsen
Subject Re: Number of rows in a cursor ?
Date
Msg-id 430C4B7F.4030907@netgroup.dk
Whole thread Raw
In response to Re: Number of rows in a cursor ?  (Thomas Borg Salling <tbs@navicon.dk>)
List pgsql-sql
Thomas Borg Salling wrote:

> Bo Lorentsen wrote:
>
>> Is it possible to get the total number of rows found in a cursor, or 
>> must I make a count(*) and then a select ?
>
>
> Perhaps:
> GET DIAGNOSTICS rc = ROW_COUNT;

Ok, and when I use the C interface the "DECLARE .." function will return 
the row count ?

Can I use PQntuples( res ) after the "DECLARE CURSOR" statement (if so, 
it don't work for me :-)) ?

/BL


pgsql-sql by date:

Previous
From:
Date:
Subject: Re: Number of rows in a cursor ?
Next
From: Bo Lorentsen
Date:
Subject: Re: Number of rows in a cursor ?