Reset the cursor to start from the record 1 - Mailing list pgsql-general

From Igor Korot
Subject Reset the cursor to start from the record 1
Date
Msg-id CA+FnnTznMxRSr98RdbVCXWnScSZOjyJ5HnJ5f3eBJRd20D0iMg@mail.gmail.com
Whole thread Raw
Responses Re: Reset the cursor to start from the record 1  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
 Hi, ALL,
I'd like to do the following:

[code]
PGresult res = PQprepare();
if( PQresultStatus( res ) != PGRES_COMMAND_OK )
{
// error handling
}
else
{
    PGresult res1 = PQexecPrepared();
    status = PQresultStatus( res1 );
    if( status != PGRES_COMMAND_OK && status != PGRES_TUPLES_OK )
    {
// error handling
    }
    else if( status == PGRES_TUPLES_OK )
    {
        for( int j = 0; j < PQntuples( res1 ); j++ )
        {
// process the recordset
        }
        for( int j = 0; j < PQntuples( res1); j++ )
        {
// process the same recordset again
        }
    }
}
[/code]

Is there a function which just reset the record pointer to 1, so I can reprocess
those records?

Thank you.


pgsql-general by date:

Previous
From: "Sven R. Kunze"
Date:
Subject: Re: Code of Conduct plan
Next
From: "Ozz Nixon"
Date:
Subject: RE: Code of Conduct plan