Advertisement
rafibatam

PL/pgSQL Constants

Jul 31st, 2019
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DO $$
  2. DECLARE
  3.     initial_price   CONSTANT    NUMERIC := 20000;
  4.     selling_price               NUMERIC := 24000;
  5. BEGIN
  6.     RAISE NOTICE 'The profit is %', selling_price - initial_price;
  7. END $$;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement