parakeet / consumer / src / db / sql / starterpack_upsert.sql

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