First I use SPI_execute("update ....
  bool succ;
   SPI_connect();
    int ret = SPI_execute("update ....where uid = 1", false, 1);//later will
add error processing
    if (ret == SPI_OK_UPDATE && SPI_processed == 1) {
        succ = true;
   }
   SPI_finish();

Then I use SPI_execute("select .....where uid = 1", ....

    SPI_connect();
    int ret = SPI_execute("select .....where uid = 1", true, 1);//later will
add error processing
    if (ret == SPI_OK_SELECT && SPI_processed == 1) {
           HeapTuple tuple;
           tuple = SPI_tuptable->vals[0];
              ...
           datum = heap_getattr(tuple,attrno,SPI_tuptable->tupdesc,&isnull);
           ....
    }
the datum doesn't change, why ?

Reply via email to