Run Code
|
API
|
Code Wall
|
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
PosgresSQL Sandbox: Legitimate Resale
Branch
PostreSQL: Subquery
PC02-DB-UTEC
postgresql timestamp
Many to many
Pedido_Insert_Delete
Movie Rating SQL Analysis Project
sss
Mandelbrot