Guest User

Untitled

a guest
Nov 24th, 2017
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. FOR my_var IN select distinct some_column from some_table LOOP
  2. -- do stuff with my_var
  3. END LOOP;
  4.  
  5. ERROR: loop variable of loop over rows must be a record
  6. or row variable or list of scalar variables
  7.  
  8. DECLARE
  9. somerow RECORD;
  10. my_var TEXT;
  11. FOR somerow IN select distinct some_column from some_table LOOP
  12. my_var := somerow.somecolumn;
  13. -- do stuff with my_var
  14. END LOOP;
  15.  
  16. DECLARE
  17. idontcare INT;
  18. my_var TEXT;
  19. FOR my_var, idontcare IN select distinct some_column, 1 from some_table LOOP
  20. -- do stuff with my_var
  21. END LOOP;
Add Comment
Please, Sign In to add comment