help with SPI_ Please - Mailing list pgsql-general

Hello experts.

 I am writing my first function using the SPI_ interface.

 I don't know how to access data that I just selected.

 here's the outline:

 my question is in the block comments

 thanks a ton!!!!

 mike



int32 allocate_address(int32 networkID)
{
    char[255]  query;

    if (SPI_connect() < 0) {
       return 0;
    }

    sprintf(query,
            "Select addressID FROM networkaddress WHERE networkid = %i",
            networkID);

    if (SPI_exec(query, 1) < 0) {
       return 0;
    }

    /* ############################################################ */
    /* how do I access the data that I just selected ?               */
    /* ie I want to find the value of the each row in the select
    /* ############################################################ */

    SPI_finish();

    return 1;
}
~