Skip to content

Content Tagged "loop"

Page 1 of 1

Content Tagged "loop"

BAT Files: Execute Multiple Commands in a Loop

October 3, 2014Category: Software
One of the tasks the other day was to load a large DB organised by year. The most efficient way was to loop through a sequence of years and execute the loader for each one. The first iteration I ended with was: This means: For years from 1996 to 1998, with an increment of one, execute my load.bat…

PostgreSQL: Call a Stored Procedure for Every Row

May 13, 2014Category: Software
I guess that newbies in PostgreSQL like me have first question when they create a store procedure: How do I call it? The answer is simple; you just execute Then, usually immediately the second question pops up: I wrote a procedure which I need to call for each row in a table. How do I do that? The…

All tags