- let sth = dbh#prepare_cached "update files
- set name_deleted = name, name = null
- where hostid = ? and id = ?
- and name is not null" in
- sth#execute [`Int hostid; `Int id];
+ PGSQL(dbh) "update files
+ set name_deleted = name, name = null
+ where hostid = $hostid and id = $id
+ and name is not null";