Postgres 8.4

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version

PostgreSQL 8.4.22lts6 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 64-bit

SELECT

-- window functions arrived in PostgreSQL 8.4
select x, sum(x) over (order by x) as running_total
from generate_series(1,5) as g(x);

x
running_total

1
1

2
3

3
6

4
10

5
15

SELECT

-- so did recursive CTEs
with recursive countdown(n) as (
  select 5
  union all
  select n - 1 from countdown where n > 1
)
select n from countdown;

n

5

4

3

2

1

SELECT