rebuild_supergroup

rebuild_supergroup
Prev	Data Analysis Procedures	Next

Name

rebuild_supergroup — rebuild the Supergroup and Delayed_Supergroup columns of the MEMBERS table for an individual

Synopsis

int rebuild_supergroup ( sname);


                  char(3)
                  sname

;

Input

sname

A Sname.

Description

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

If this individual has 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 any of the individual's rows in the RESIDENCIES table.

Note

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

Example

SELECT rebuild_supergroup('FOO');

Prev	Up	Next
rebuild_all_sexskins	Home	rebuild_all_supergroup