| 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: | Whole Thread | Raw Message | 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 |