Links

Interesting links on database topics

Error "Multiple updates to a row by the same query is not allowed"

Finding arrays that contain a subset of another array without using @> with postgreSQL

Postgres Top 10 2016

PSequel

Delete duplicate rows in Postgres

Simple case for pivoting

Selecting random rows in Postgres

Update multiple rows in Postgres

The filter clause

Understanding star schemas

Weighted random sampling with Postgres

Select if string contains in Postgres

Is count(*) or count(1) faster?

Literate SQL