PostgreSQL
Find the number of the longest continuously rising days for a stock
Today I want to react to an article that claims that Relational Algebra Is the Root of SQL Problems in which the author hand-waves the following position: SQL becomes …
tag
Window-Functions
5 posts
PostgreSQL
Exploring a Data Set in SQL
Sometimes you need to dive in an existing data set that you know very little about. Let’s say we’ve been lucky to have had a high level description of the …
PostgreSQL
Understanding Window Functions
There was SQL before window functions and SQL after window functions: that’s how powerful this tool is. Being that of a deal breaker unfortunately means that it can …
Conferences
Make the Most ouf of SQL
Tonight I had the pleasure to present a talk at the Dublin PostgreSQL User Group using remote technologies. The talk is about how to make the most ouf of PostgreSQL when …
PostgreSQL
Reset Counter
I’ve been given a nice puzzle that I think is a good blog article opportunity, as it involves some thinking and window functions.