Get the latest tech news

A PostgreSQL planner semi-join gotcha with CTE, LIMIT, and RETURNING

How a seemingly straightforward DELETE query using a CTE and LIMIT returned more rows than expected due to query planner optimization.

A PostgreSQL planner gotcha with CTEs DELETE and LIMIT

Get the Android app