Hello,
I'd like to write a C Function for Postgresql that can access data in
the database, use that to conduct additional queries to find more
information in the database and eventually return a result. I
currently have the functionality I want implemented as php/C programs
that first connect to the database, do the processing and then
disconnect, but I want to make it what I think is called a "stored
procedure" in other databases. It seems odd that I would write a C
program to be included in the database that connects to the localhost
- is that what I should do? Is that somehow more efficient than
running it as a separate process?
I've looked into C Functions but the examples I've found have talked
about performing calculations on the arguments. Table function
examples show how I might return more than one row or multi-columned
rows, but I don't see how to actually access the data in the database.
I apologize if this question is answered somewhere. I suspect it is
but I apparently don't know the terminology to look it up and have
spent an hour conducting fruitless Google searches. A pointer to such
a resource along with the topic I should check out would be more than
helpful.
Thanks,
Jeff