create_add_missing_stocks.sql 218 B

12345678910
  1. CREATE OR REPLACE FUNCTION add_missing_stocks() RETURNS void AS
  2. $$
  3. DECLARE
  4. proCursor CURSOR IS SELECT pro_id FROM Product;
  5. proId Product.pro_id%TYPE;
  6. BEGIN
  7. RAISE NOTICE 'Bonjour';
  8. END;
  9. $$
  10. LANGUAGE plpgsql;