E
Size: a a a
E
IZ
AL
ziv@mogera:~$ bpytop
File "/snap/bpytop/116/usr/bin/bpytop", line 34
errors: List[str] = []
^
SyntaxError: invalid syntax
ziv@mogera:~$
IZ
IZ
ДМ
CREATE OR REPLACE FUNCTION public.increment_updated_times()
RETURNS trigger
LANGUAGE plpgsql
AS $function$
begin
if
old.contact_name <> new.contact_name or
old.company <> new.company or
old.contact_group <> new.contact_group or
old.email <> new.email or
old.account_name <> new.account_name or
old.job_title <> new.job_title then
new.updated_times = old.updated_times+1;
return new;
end if;
raise notice 'Hello world';
return new;
END;
$function$
;
create trigger increment_trigger after
update
on
public.contacts for each row execute function increment_updated_times()
ДМ
E
D9
D9
VY
SELECT event_time,
install_time,
event_time :: timestamp - install_time :: timestamp diff,
DATE_PART('hours', event_time :: timestamp - install_time :: timestamp) part
FROM collector.collector_appsflyer.raw_data_in_app_events
WHERE task_id IN (27, 28)
ORDER BY diff
LIMIT 1000;
SB
SELECT event_time,
install_time,
event_time :: timestamp - install_time :: timestamp diff,
DATE_PART('hours', event_time :: timestamp - install_time :: timestamp) part
FROM collector.collector_appsflyer.raw_data_in_app_events
WHERE task_id IN (27, 28)
ORDER BY diff
LIMIT 1000;
AL
SB
CREATE OR REPLACE FUNCTION public.increment_updated_times()
RETURNS trigger
LANGUAGE plpgsql
AS $function$
begin
if
old.contact_name <> new.contact_name or
old.company <> new.company or
old.contact_group <> new.contact_group or
old.email <> new.email or
old.account_name <> new.account_name or
old.job_title <> new.job_title then
new.updated_times = old.updated_times+1;
return new;
end if;
raise notice 'Hello world';
return new;
END;
$function$
;
create trigger increment_trigger after
update
on
public.contacts for each row execute function increment_updated_times()
ДМ
TT