From: | Mike Haberman <mikeh(at)ncsa(dot)uiuc(dot)edu> |
---|---|
To: | mikeh(at)ncsa(dot)uiuc(dot)edu (Mike Haberman) |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | help with SPI_<commands> Please |
Date: | 1999-06-30 22:01:10 |
Message-ID: | 199906302201.RAA27069@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
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;
}
~
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 1999-06-30 22:17:15 | Re: [GENERAL] urgent: problems with query_limit |
Previous Message | Mike Haberman | 1999-06-30 21:57:18 | help with SPI_<commands> Please |