On Mon, Sep 26, 2011 at 4:22 PM, Marti Raudsepp wrote:
> On Mon, Sep 26, 2011 at 18:59, Andy Chambers wrote:
>> ...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 th
On Mon, Sep 26, 2011 at 18:59, Andy Chambers wrote:
> ...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 a
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,
l
