Re: How do you execute a postgresql function from perl?

Nigel,
Thank you very much for the information. I'm going to try your example.
It's been driving me crazy that I couldn't get it to work, because it's
pretty basic functionality. I'll code it this weekend and let you know
what happens.

Thanks again,

Stu Krone


On Fri, 2003-04-11 at 15:04, Nigel J. Andrews wrote:
> 
> 
> I meant to give a perl example.
> 
> Using DBI:
> 
> $sth = $dbh->prepare('select myfunc2(?)');
> $rv = $sth->execute($myvar);
> print "Number rows = ", $sth->rows, "\n";
> while ($data = $sth->fetchrow_array) {
>     print "Data: ", $data[0], "\n";
> }
> $sth->finish;
> 
> I can't remember the Pg.pm syntax, I only see that in support mode at the
> moment so don't really pay much attention to it.
> 
> 
> -- 
> Nigel J. Andrews
>