prepared queries in plperl

Поиск
Список
Период
Сортировка
От Dmitry Karasik
Тема prepared queries in plperl
Дата
Msg-id 84br2evmdd.fsf@tetsuo.karasik.eu.org
обсуждение исходный текст
Ответы Re: prepared queries in plperl  ("Andrew Dunstan" <andrew@dunslane.net>)
Список pgsql-hackers
Hello,

I've posted before a patch that enables prepared queries in plperl, and
now, after a while, as it seems working as expected, I'd like to ask if it
would be a reasonable thing to commit in into -devel? The patch against
the latest cvs is at http://www.karasik.eu.org/misc/plperl.diff .

The idea behind the patch is to make it possible to pass non-interpolated
parameters to the query:

CREATE OR REPLACE FUNCTION plus_one(INTEGER) RETURNS INTEGER AS $$ my $x = spi_prepare('SELECT $1 AS datum', 'INT4');
my$rv = spi_exec_prepared($x, $q + 1); spi_freeplan( $x); return $rv->{rows}[0]->{datum};
 
$$ LANGUAGE plperl;

-- 
Thanks,Dmitry Karasik






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

Предыдущее
От: Andrey Repko
Дата:
Сообщение: Strange, very strange
Следующее
От: "Andrew Dunstan"
Дата:
Сообщение: Re: prepared queries in plperl