db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

An UPDATE leaves the old tuple behind

An UPDATE writes a new version at the next free line pointer and sets xmax and t_ctid on the old one.

task

Update id 1 (n = n + 1), then show lp, whether xmax is set, and t_ctid of line pointers 1 and 101, ordered by lp.

hints