======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