Re: SPI_????

Tourtounis Sotiris <tourtoun@csd.uoc.gr> writes:

> I want to ask a question that it may look totally stupid but i have stacked as
> a new user of postgresql!!!
>
> I want to take the result of a sql question of the general type "select
> att0 ..." where att0 is text and to store it to a C variable of char *. I
> have read that there is the SPI_exec that returns a number of the returned
> tupels of the question - if the result of my question is the SPI_getvalue
> could anyone show me a small example how to use it  -if it's something
> else i would appreciate your advice .Thanks a priori.

SPI is only for C functions running inside of the database server.  Is
this what you're actually doing?

If you're making client queries from a standalone C program, the libpq
API should do what you want and is amply documented.

-Doug