Window functions are a very useful tool; and since their introduction 10 years ago, they have been gradually adopted for various use cases where a simple aggregation is not flexible enough: for example incremental totals, moving averages, etc. The latest features introduced in PostgreSQL complete the implementation according to the SQL:2011 standard, adding capabilities such […]
About Bilal Ibrar
Bilal Ibrar is a PostgreSQL enthusiast and contributes regularly to 2ndQuadrant blog.
Entries by Bilal Ibrar
For businesses handling personal data, security of their database is a serious matter. Faced with an increasing number of attacks, an organization must improve their security and compliance policies, improve their database infrastructure and ensure all proper security protocols are in place.