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…
Weiterlesen11.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…
Weiterlesen