Restock book 1 to 20 using INSERT … ON CONFLICT (id) DO UPDATE SET stock = EXCLUDED.stock, and RETURN id and stock.
Restock book 1 to 20 using INSERT … ON CONFLICT (id) DO UPDATE SET stock = EXCLUDED.stock, and RETURN id and stock.
Answer
INSERT INTO books (id, title, author_id, genre, price, stock) VALUES (1, 'The Glass Forest', 1, 'fiction', 14.99, 20) ON CONFLICT (id) DO UPDATE SET stock = EXCLUDED.stock RETURNING id, stock;