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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings