Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Recursive inefficiency
create table events as select * from generate_series(1,10000) as event_time; create or replace function strain_events() returns setof events language plpgsql as $$ declare curr record; prev int; begin for curr in select * from events order by 1 loop if prev is null or curr.event_time >= prev + 10 then return next curr; prev = curr.event_time; end if; end loop; end $$; --select * from strain_events(); with recursive r(x) as ( select min(event_time) as x from events t union all (select t.event_time as x from events t join r on (t.event_time >= r.x + 10) order by t.event_time limit 1)) select * from r;
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
SQL Moving Rating Practice by Han Wang 20200720
Professional Networking Social Media Website SQL Analysis
Assignment 1(SET A)
enrj
base de datos api teclab
Assignment
75 95
first
hell
G.Giftcard Interview Analysis Conducted by Miranda Zhao
Please log in to post a comment.