Re: spi and other languages

Sibtay Abbas <sibtay_abbas(at)yahoo(dot)com> writes:

> We can call SQL statements like SPI_Execute("SELECT *
> FROM sometable") from the spi interface. My question
> is that can we enter other procedural languages as
> well, like pgplsql statements.

You can call a function written in another procedural langauge by
executing a SELECT:

SPI_Execute("SELECT myfunction()")

But you can't execute arbitrary code in other langauges using SPI (of
from the client side, for that matter)--it has to be wrapped up in a
function.

-Doug