postgresql

01.12.2022

SQL date range queries

In my company work, we often use two Date or DateTime fields to express a range when the row data is valid. CREATE TABLE test ( id int NOT NULL PRIMARY KEY, title varchar(255) NULL, valid_from…

11.03.2020

PostgreSQL revisited

I still remember when I heard PostgreSQL for the first time. It was around 2001, when my former room mate mentioned that he was a maintainer for PostgreSQL on Debian. At that time, I was still…