Sibtay Abbas <sibtay_abbas@yahoo.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