postgresql7.1 update ec_gift_certificates set gift_certificate_state='void', voided_date=current_timestamp, voided_by=:customer_service_rep, reason_for_void=:reason_for_void where gift_certificate_id=:gift_certificate_id