Skip to content

Instantly share code, notes, and snippets.

@maxclark

maxclark/range.sql

Last active August 29, 2015 14:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save maxclark/888de5bd17aee17b3817 to your computer and use it in GitHub Desktop.
Save maxclark/888de5bd17aee17b3817 to your computer and use it in GitHub Desktop.
Download ZIP
Repeat a query inserting a range of numbers
Raw
range.sql
INSERT into orig_route_cos_dest (orig_route_id, priority, class_dest, final)
SELECT gs.i, '1', 'bg:14', 't' f
FROM generate_series(417, 437) gs(i);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment