postgresql7.1 update ec_subcategories set subcategory_name=:subcategory_name, last_modified=current_timestamp, last_modifying_user=:user_id, modified_ip_address=:address where subcategory_id=:subcategory_id