Sibtay Abbas <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
