Hi all,

    I have some doubts about SPI (Server Programming Interface). In fact, I must create Stored Procedures in Postgres (8.0). The problem is: all stored procedures and, may be, some triggers must be compiled 'cause the clients can't access the source code of them.
    To solve this problem, the solution that I was found is create the procedures (functions) in C with SPI to access the database.
    Now, the functions are writed in plgpsql. There are another ways to compile the code? If not, someone there are samples how can I use C with SPI?

Regards,
Danilo