Name

rebuild_all_supergroup — rebuild the Supergroup and Delayed_Supergroup columns of the entire MEMBERS table

Synopsis

int rebuild_all_supergroup ( );  
 

Description

This procedure rebuilds the Supergroup and Delayed_Supergroup columns on the entire MEMBERS table. The GROUPS, CENSUS (by way of MEMBERS), and BIOGRAPH tables provide the necessary data.

If there are any MEMBERS rows with non-NULL Residency, LowFrequency, or GrpOfResidency, those values depended on an earlier version of the supergroup data, so this function automatically sets them all to NULL and removes all rows in the RESIDENCIES table.

Note

The Supergroup and Delayed_Supergroup columns of the MEMBERS table are not automatically maintained by the system at this time.

Example

SELECT rebuild_all_supergroup();


Page generated: 2024-04-22T16:19:44-04:00.