Re: SPI using perl

my $query = "SELECT sp_insert(" . $a . "," . $b . "," . $c . ")";
my $exec_query = spi_exec_query($query);

here i'm calling a function sp_insert and passing parameters a,b,c to it.

Is this the right usage to spi_exec_query?

Thanks,
~Jas

On 6/22/07, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
>
> Jasbinder Singh Bali wrote:
> > Hi
> > I was wondering if its necessary to download DBI::PgSPI package from
> > CPAN to use spi_exec_query in perl
>
> No. Using plperl is the way to go. See the docs there are examples under
> plperl.
>
> Joshua D. Drake
>
> > or it can be used without downloading the above mentioned package. I've
> > tried using spi_exec_query without that package
> > but doesn't work.
> >
> > Thanks,
> > Jas
>
>
> --
>
> === The PostgreSQL Company: Command Prompt, Inc. ===
> Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
> Providing the most comprehensive PostgreSQL solutions since 1997
> http://www.commandprompt.com/
>
> Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
> PostgreSQL Replication: http://www.commandprompt.com/products/
>
>