22 lines
1.2 KiB
SQL
22 lines
1.2 KiB
SQL
UPDATE transactional.field_perf_summary
|
|
SET
|
|
erpmdrop_straight_1stpass_low = trim(split_part(trim(straight_road_rpm_drop), '-', 1))::numeric,
|
|
erpmdrop_straight_1stpass_high = case trim(split_part(trim(straight_road_rpm_drop), '-', 2))
|
|
when '' then null
|
|
else trim(split_part(trim(straight_road_rpm_drop), '-', 2))::numeric end,
|
|
erpmdrop_turn_1stpass_low = trim(split_part(trim(up_slope_rpm_drop_1), '-', 1))::numeric,
|
|
erpmdrop_turn_1stpass_high = case trim(split_part(trim(up_slope_rpm_drop_1), '-', 2))
|
|
when '' then null
|
|
else trim(split_part(trim(up_slope_rpm_drop_1), '-', 2))::numeric end,
|
|
--updating RPM drop up slop 2nd pass:
|
|
erpmdrop_turn_2ndpass_low = trim(split_part(trim(up_slope_rpm_drop_2), '-', 1))::numeric,
|
|
erpmdrop_turn_2ndpass_high = case trim(split_part(trim(up_slope_rpm_drop_2), '-', 2))
|
|
when '' then null
|
|
else trim(split_part(trim(up_slope_rpm_drop_2), '-', 2))::numeric end,
|
|
--updating down slope rpm shoot up :
|
|
erpmdrop_turn_3rdpass_low = trim(split_part(trim(down_slope_rpm_shoot_up), '-', 1))::numeric,
|
|
erpmdrop_turn_3rdpass_high = case trim(split_part(trim(down_slope_rpm_shoot_up), '-', 2))
|
|
when '' then null
|
|
else trim(split_part(trim(down_slope_rpm_shoot_up), '-', 2))::numeric end
|
|
where file_mnemonic = 'FTHLG';
|