Changeset View
Changeset View
Standalone View
Standalone View
sql/upgrades/049.sql
Show First 20 Lines • Show All 77 Lines • ▼ Show 20 Lines | |||||
create or replace function update_occurrence_for_origin(origin_id bigint) returns void language sql as $$ | create or replace function update_occurrence_for_origin(origin_id bigint) returns void language sql as $$ | ||||
delete from occurrence where origin = origin_id; | delete from occurrence where origin = origin_id; | ||||
insert into occurrence (origin, branch, target, target_type) | insert into occurrence (origin, branch, target, target_type) | ||||
select origin, branch, target, target_type from occurrence_history | select origin, branch, target, target_type from occurrence_history | ||||
where origin = origin_id | where origin = origin_id | ||||
and (select visit from origin_visit | and (select visit from origin_visit | ||||
where origin = origin_id | where origin = origin_id | ||||
order by date desc | order by date desc | ||||
limit 1) = any(visits); | limit 1) = any(visits); | ||||
$$; | $$; | ||||
create or replace function update_occurrence() returns void | create or replace function update_occurrence() returns void | ||||
language plpgsql as | language plpgsql as | ||||
$$ | $$ | ||||
declare | declare | ||||
origin_id origin.id%type; | origin_id origin.id%type; | ||||
begin | begin | ||||
▲ Show 20 Lines • Show All 175 Lines • Show Last 20 Lines |