<?xml version="1.0" encoding="windows-1252"?>
<node id="513947" title="Re: OT: Postgres, now(), and bindvars" created="2005-12-04 08:26:54" updated="2005-12-04 03:26:54">
<type id="11">
note</type>
<author id="227005">
cees</author>
<data>
<field name="doctext">
&lt;p&gt;You can't put a ? inside a quoted string in your SQL statement as DBI won't see it as a placeholder, but as a simple string.  I just pulled the following out of some existing code I wrote a while ago, so I know it works:&lt;/p&gt;

&lt;code&gt;
INSERT INTO eventdates (eventdate, event, date)
VALUES (?, ?, ?::timestamp + ?::interval)
&lt;/code&gt;

&lt;p&gt;So what you need to do is add the ' minutes' part to a perl variable and pass that entire string to the placeholder.&lt;/p&gt;
</field>
<field name="root_node">
513943</field>
<field name="parent_node">
513943</field>
</data>
</node>
