create_add_missing_stocks.sql 412 B

123456789101112131415161718
  1. CREATE OR REPLACE FUNCTION add_missing_stocks() RETURNS void AS
  2. $$
  3. DECLARE
  4. proCursor CURSOR FOR SELECT pro_id FROM Product;
  5. proId Product.pro_id%TYPE;
  6. BEGIN
  7. RAISE NOTICE 'Start';
  8. OPEN proCursor;
  9. LOOP
  10. FETCH proCursor INTO proId;
  11. EXIT WHEN proId IS NULL;
  12. RAISE NOTICE 'Loop %', proId;
  13. END LOOP;
  14. CLOSE proCursor;
  15. RAISE NOTICE 'End';
  16. END;
  17. $$
  18. LANGUAGE plpgsql;