-- -- content_item__set_release_period/3 -- create or replace function content_item__set_release_period( integer, timestamp with time zone, timestamp with time zone ) returns int4 as $$ declare set_release_period__item_id alias for $1; set_release_period__start_when alias for $2; -- default null set_release_period__end_when alias for $3; -- default null v_count integer; begin select count(*) into v_count from cr_release_periods where item_id = set_release_period__item_id; if v_count = 0 then insert into cr_release_periods ( item_id, start_when, end_when ) values ( set_release_period__item_id, set_release_period__start_when, set_release_period__end_when ); else update cr_release_periods set start_when = set_release_period__start_when, end_when = set_release_period__end_when where item_id = set_release_period__item_id; end if; return 0; end;$$ language plpgsql;