Skip to content

Instantly share code, notes, and snippets.

@waltton

waltton/update-product-log.sql

Last active November 5, 2022 13:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save waltton/0361ff9c6537d390fc78db9b6cc89ec0 to your computer and use it in GitHub Desktop.
Save waltton/0361ff9c6537d390fc78db9b6cc89ec0 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
update-product-log.sql
-- Let's create a table, product_log, to capture the price changes over time
CREATE TABLE product_log (
product_id UUID,
price NUMERIC,
date_updated TIMESTAMP(0) WITH TIME ZONE DEFAULT NOW()
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment