update-increase10perc.sql

-- after a while
SELECT pg_sleep(1);

-- I started to think about it again, cat owners will pay anything to make their cats happy
-- So let's make this at least 10% more expensive
UPDATE product
SET price = price * 1.1
  , date_updated = NOW();

SELECT substring(id::text, 1, 5) || '...' AS id, name, to_char(price, '999D99') AS price, '... ' || substring(date_added::text, 12, 8) AS date_added, '... ' || substring(date_updated::text, 12, 8) AS date_updated FROM product;
--     id    |         name         |  price  |  date_added  | date_updated
-- ----------+----------------------+---------+--------------+--------------
--  3da19... | feather on the stick |   11.00 | ... 16:53:59 | ... 16:54:00
--  156a6... | mouse on the stick   |   13.20 | ... 16:53:59 | ... 16:54:00
--  4ad03... | bed cavern           |  152.90 | ... 16:53:59 | ... 16:54:00
--  1612f... | scratch toy          |   31.90 | ... 16:53:59 | ... 16:54:00
--  b9803... | loud bell ball       |    8.80 | ... 16:53:59 | ... 16:54:00
-- (5 rows)