Articles tagged 'sql' | boringSQL

The DISTINCT in your COUNT

The tests passed. The plan didn't.

Same rows, different SUM

The NULL in your NOT IN

Welcome to ORDER BY jungle

Strong views on PostgreSQL VIEWs

Good CTE, bad CTE

The hidden cost of PostgreSQL arrays

RegreSQL: Regression Testing for PostgreSQL Queries

Beyond Start and End: PostgreSQL Range Types

Time to Better Know The Time in PostgreSQL

VIEW inlining in PostgreSQL

DELETEs are difficult

Text identifiers in PostgreSQL database design

We need to talk about ENUMs

Beyond Simple Upserts with MERGE in PostgreSQL

Gentle Introduction to Window Functions in PostgreSQL