On 12/11/2013 06:42 PM, John SJ Anderson wrote:
[snip]
> "With most drivers, placeholders can't be used for any element of a
> statement that would prevent the database server from validating the
> statement and creating a query execution plan for it."
>
> I suspect you're running afoul of that...
On Wed, Dec 11, 2013 at 1:56 AM, Lars Noodén wrote:
> my $sth = $dbh->prepare("delete from sessions where \
> current_timestamp - time > interval ?");
>
> $sth->execute( $interval );
>
>
> What mistake is there causing the error? I can use a similar line with
> a placeholder for a SELECT sql s
I have an sql statement which works fine in the psql client:
delete from sessions where current_timestamp - time > interval '00:02:00';
but when I try it using DBI, it produces this error:
DBD::Pg::st execute failed: execute called with an unbound
placeholder ...
That part o
