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