PG Phriday: Through the Window

Now that we know how Postgres [intlink id='pg-phriday-in-the-window']window functions work[/intlink], why not play with them a bit to get a better understanding of their capabilities? So long as we understand window functions are applied after data gathering and aggregation steps, much of their mystery and complexity is defanged. Let’s start actually using them for stuff!

[caption id="attachment_1396" align="aligncenter" width="480"] Captain Murphy is tired of your nonsense[/caption]