Postgres 9.4 was released in December 2014 adding the FILTER clause to aggregate functions and this clause is quite useful when you want to count or sum specific records when executing group by.
How I learned a new programming language having fun and using tests.
Command validation and responses
Have you ever needed to use a helper method inside your controller? I did, a few…
By default Postgres will order by ASC and NULL values will be placed on the end of list, but with the NULLS {FIRST|LAST} option you can setup the ordering by NULL values as you wish:
How to return data related to updated rows.
Here is my situation. I have a products table and each product needs to be approved by someone.
From time to time we need to investigate if there is any query running indefinitely on our PostgreSQL database.
These long running queries may interfere on the overall database performance and probably they are…