On Mon, Aug 08, 2005 at 09:27:15AM +0200, Stephan Springer wrote:
> my $sth = $dbh->prepare('select interval ?');
> DBD::Pg::st execute failed: ERROR: syntax error at or near "$1" at character
> 17
Hi,
this seems to be by design. It's also CPAN #17879 and #16992 (which
doesn't help much, though.) The comments in
http://gborg.postgresql.org/pipermail/dbdpg-general/2006-January/001972.html
http://gborg.postgresql.org/pipermail/dbdpg-general/2006-February/002007.html
list some workarounds: either turning off the server-side prepares
through the pg_server_prepare flag or using eg. '?::interval' instead of
'interval ?', as already suggested in #321917 as well.
Cheers,
--
Niko Tyni [EMAIL PROTECTED]
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
