Name

rebuild_new_members — for all individuals with any rows that haven't had their supergroups constructed or residency analyzed, re-interpolate all their MEMBERS rows, re-construct all their Supergroup and Delayed_Supergroup columns, and re-analyze the residency information for all their MEMBERS rows

Synopsis

int rebuild_new_members ( );  
 

Description

This procedure queries MEMBERS to determine which individuals have any rows with NULL Supergroup, Delayed_Supergroup, or Residency, and then re-interpolates all of the MEMBERS rows for those individuals. The CENSUS table provides the data necessary to rebuild the MEMBERS rows.

The MEMBERS.Supergroup and Delayed_Supergroup columns and the residency columns for all those individuals' MEMBERS rows are also re-computed.[311]

Caution

rebuild_members is something of a misnomer because the program assumes that MEMBERS already contains all the (non-absent) CENSUS rows. See rebuild_members().

Example

SELECT rebuild_new_members();




Page generated: 2025-04-10T11:37:43-04:00.