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

Поиск
Список
Период
Сортировка
От Nigel J. Andrews
Тема Re: How do you execute a postgresql function from perl?
Дата
Msg-id Pine.LNX.4.21.0304112259460.31910-100000@ponder.fairway2k.co.uk
обсуждение исходный текст
Ответ на Re: How do you execute a postgresql function from perl?  (Stu Krone <skrone@blueonyxgroup.com>)
Ответы Re: How do you execute a postgresql function from perl?
Re: How do you execute a postgresql function from perl?
Список pgsql-hackers

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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Kevin Brown
Дата:
Сообщение: Re: Anyone working on better transaction locking?
Следующее
От: Greg Stark
Дата:
Сообщение: Re: [GENERAL] medical image on postgreSQL?