parakeet / consumer / src / db / sql / list_upsert.sql

INSERT INTO lists (at_uri, owner, cid, list_type, name, description, description_facets, avatar_cid, created_at)
VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9)
ON CONFLICT (at_uri) DO UPDATE SET cid=EXCLUDED.cid,
                                   list_type=EXCLUDED.list_type,
                                   name=EXCLUDED.name,
                                   description=EXCLUDED.description,
                                   description_facets=EXCLUDED.description_facets,
                                   avatar_cid=EXCLUDED.avatar_cid,
                                   indexed_at=NOW()
RETURNING XMAX::text::int