SPI

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