plperl and table/record access

Поиск
Список
Период
Сортировка
От Gordan Bobic
Тема plperl and table/record access
Дата
Msg-id 200110241614.f9OGE6M09853@sentinel.bobich.net
обсуждение исходный текст
Ответ на Re: locking and web interfaces  (Alvaro Herrera <alvherre@atentus.com>)
Ответы Re: plperl and table/record access  (Alex Pilosov <alex@pilosoft.com>)
Список pgsql-general
Hi.

How do I manipulate data in tables from within plperl? Can I, for example,
issue SQL statements from within plperl functions? I haven't managed to find
any documentation on this subject. Can anyone point me in the correct
direction, please? I'm trying to write some trigger functions...

I have seen an example with the plperl function that performs a calculation
on each row of a table, but it is not explained anywhere how to insert
records, or how to locate specific records without having to loop through the
entire database. I presume that DBI will not work, given the need for setting
up separate database connections, authentication, etc.

Thanks.

Gordan

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

Предыдущее
От: "Ben-Nes Michael"
Дата:
Сообщение: Re: Disable Transaction - plans ?
Следующее
От: Doug McNaught
Дата:
Сообщение: Re: Disable Transaction - plans ?