Hi,
I have a need to write a query that batches up rows of a table into
groups of n records. I feel like this should be possible using the
existing window functions but I can't figure out how to do it from the
examples.
So I have some table, let's say
create table addresses (
line_1 text,
line_2 text,
city text,
state text,
zip text);
...and I want to select the data from that table, adding a "group_id"
column, and a "record_id" column. The "group_id" would start at 1,
and increment by 1 every 100 rows, and the "record_id" would increment
by 1 every row, but restart at 1 for each new group_id.
Thanks,
Andy