======Common DB Operations======

Some common database operations.

=====Merging Duplicate Candidates=====

Merging duplicate candidates is pretty straight forward with the appropriate function.  It moves all related data from one candidate to another.  

**NOTE**: Nothing in the candidate table will be moved.  This is up to Research to do.

%%(sql)
BEGIN;
SELECT pvs_merge_candidate([duplicate_id], [destination_id]);
COMMIT;
%%

duplicate_id is the candidate_id that was created as a duplicate and no longer wanted. destination_id is where you want things moved(also a candidate_id).

----
CategoryITDoc