LQPP/man half freeze.sql
< LQPP
BEGIN; UPDATE issue SET half_frozen=now() WHERE issue.policy_id IN (1,2,3) AND accepted NOTNULL AND half_frozen ISNULL AND closed ISNULL; COMMIT;
BEGIN; UPDATE issue SET half_frozen=now() WHERE issue.policy_id IN (1,2,3) AND accepted NOTNULL AND half_frozen ISNULL AND closed ISNULL; COMMIT;