November 19, 2026: PostgreSQL 19 Released!

Feature Description

INSERT ... ON CONFLICT DO SELECT

INSERT ... ON CONFLICT DO SELECT lets the RETURNING clause return existing rows that conflict with an insert, optionally locking them with FOR UPDATE/FOR SHARE. This simplifies the "get or create" pattern.