News for hackers. Stuff that matters.
Re:Advanced SQL window function quiz by postila on Saturday February 10, 2018 @01:04PM (#16348558)
select version();

PostgreSQL 9.3.20 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.4-2ubuntu1~14.04.3) 4.8.4, 64-bi

I wonder why so old version is being used. I will be not supported by the community pretty soon.

Re:Advanced SQL window function quiz by postila on Saturday February 10, 2018 @01:16PM (#16348621)
I mean, in more recent Postgres versions, more things related to window functions are available – like CUBE, GROUPING SETS, etc. 9.3 was released back in 2013.