Terrence Brannon wrote: > > The following SQL is not parseable by SQL::Statement: > > INSERT > INTO thot_log (thot_fk,thot_type_fk,thot_temporality_fk,date) > VALUES (?,?,?,CURRENT_TIMESTAMP) > > the error msg is : > > Parse error near CURRENT_TIMESTAMP)
What is your aim here? If you are inserting into PostgresSQL, then use DBD::Pg. If you are using SQL::Statement to check the statement first, then the PG specific CURRENT_TIMESTAMP will be treated as a string and will expect to be quoted. If you're trying something else, let me know what it is you're aiming for and I can perhaps make a suggestion. -- Jeff
