erik_flywheel
11/19/2021, 8:04 PMsilentworks
11/19/2021, 8:05 PMerik_flywheel
11/19/2021, 8:07 PMerik_flywheel
11/19/2021, 8:08 PMsilentworks
11/19/2021, 8:13 PMsql
create function public.handle_new_user()
returns trigger as $$
begin
new.full_name = new.first_name || ' ' || new.last_name
insert into public.profiles (user_id, full_name)
values (new.id, new.full_name);
return new;
end;
$$ language plpgsql security definer;
silentworks
11/19/2021, 8:14 PMerik_flywheel
11/19/2021, 8:17 PMerik_flywheel
11/19/2021, 8:32 PMsilentworks
11/19/2021, 8:34 PMsilentworks
11/19/2021, 8:34 PMerik_flywheel
11/19/2021, 8:36 PMsilentworks
11/20/2021, 1:51 PMsilentworks
11/20/2021, 1:53 PMsql
CREATE OR REPLACE FUNCTION public.update_res_info_f ()
returns trigger as $$
BEGIN
new.platform_payout = new.parking_fee * 2 ;
update public.reservations
set platform_payout = new.platform_payout
where id = new.id;
RETURN new;
END;
$$
language plpgsql security definer;
CREATE TRIGGER t5
AFTER INSERT ON reservations
FOR EACH ROW EXECUTE PROCEDURE update_res_info_f();
I've tested this in one of my projects and it works as expected.