From: | Mike Haberman <mikeh(at)ncsa(dot)uiuc(dot)edu> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | help with SPI_<commands> please ! |
Date: | 1999-06-30 21:50:19 |
Message-ID: | 199906302150.QAA26714@pecos.ncsa.uiuc.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
nt32 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;
}
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Haberman | 1999-06-30 21:57:18 | help with SPI_<commands> Please |
Previous Message | Herbert Liechti | 1999-06-30 20:58:17 | urgent: problems with query_limit |