[GENERAL] Sum raw with the same continuous flags

2013-06-01 Thread Shenli Zhu
Hi, there are 2 columns, flag(boolean) and num(integer),in a table. Table is like | flag | num | |--+-| |1 | 2 | \ 5 |1 | 3 | / |0 | 1 | \ 7 |0 | 6 | / |1 | 4 | \ 9 |1 | 5 | / | ... | ... | I want to sum up the raw with the same continuous flags. E.g. fl

Re: [GENERAL] Sum raw with the same continuous flags

2013-06-01 Thread Andreas Kretschmer
Shenli Zhu wrote: > Hi, there are 2 columns, flag(boolean) and num(integer),in a table. > Table is like > | flag | num |   > |--+-| > |    1 |   2 | \ 5 > |    1 |   3 | / > |    0 |   1 | \ 7 > |    0 |   6 | / > |    1 |   4 | \ 9 > |    1 |   5 | / > |  ... | ... |   > I want to sum up

Re: [GENERAL] Sum raw with the same continuous flags

2013-06-01 Thread Victor Yegorov
2013/6/1 Shenli Zhu > Hi, there are 2 columns, flag(boolean) and num(integer),in a table. > Table is like > | flag | num | > |--+-| > |1 | 2 | \ 5 > |1 | 3 | / > |0 | 1 | \ 7 > |0 | 6 | / > |1 | 4 | \ 9 > |1 | 5 | / > | ... | ... | > I want to sum up t

Re: [GENERAL] Sum raw with the same continuous flags

2013-06-01 Thread David Johnston
Виктор Егоров wrote > 2013/6/1 Shenli Zhu < > zhushenli@ > > > >> Hi, there are 2 columns, flag(boolean) and num(integer),in a table. >> Table is like >> | flag | num | >> |--+-| >> |1 | 2 | \ 5 >> |1 | 3 | / >> |0 | 1 | \ 7 >> |0 | 6 | / >> |1 | 4 | \ 9 >>