Vol. I · A Postgres HandbookTwelve chapters · · 756 queries

The Query & the Schema

A reading-room reference for writing PostgreSQL by hand — selects to window functions, with the schema in plain view.

EasyBasic SELECT

Select all orders with NULL shipped_at (not shipped)

SQL

SELECT order_id, cust_id, order_date, status
FROM orders
WHERE shipped_at IS NULL;

Tested against PostgreSQL 16

Note

“Always use IS NULL / IS NOT NULL. Never use = NULL.