select * from timestamp_testing where start = timestamp '2011-06-02 12:33:07' ;

##</code><code>##

 my $sth = $dbh->prepare ("SELECT * from timestamp_testing where start = (timestamp ?) ");

 if ( $sth->execute("2011-06-02 12:33:07" )){
         print Dumper $sth->fetchall_arrayref;
 }
else {
            print "WRONG QUERY\n" ;
}

##</code><code>##

DBD::Pg::st execute failed: ERROR:  syntax error at or near "$1"
LINE 1: ...ELECT * from timestamp_testing where start = (timestamp $1) 
                                                                   ^ at NORMAL_DBI.pl line 63