Re: [HACKERS] spi and other languages

2004-12-10 Thread Doug McNaught
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

Re: [HACKERS] spi and other languages

2004-12-07 Thread Michael Fuhr
On Mon, Dec 06, 2004 at 11:05:28PM -0800, Sibtay Abbas wrote: i guess the answer to my previous question was spi...i ve got another question, can we call pgsql or plpgsql functions using spi? like can we do something like SPI_execute(CREATE FUNCTION blah() RETURNS Integer .

Re: [HACKERS] spi and other languages

2004-12-07 Thread Sibtay Abbas
i am still in my RD phase so i ve not yet tried it. actually i chose the wrong example. 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.

[HACKERS] spi and other languages

2004-12-06 Thread Sibtay Abbas
i guess the answer to my previous question was spi...i ve got another question, can we call pgsql or plpgsql functions using spi? like can we do something like SPI_execute(CREATE FUNCTION blah() RETURNS Integer . __ Do you Yahoo!?