Hi,
I have a table of about 693 million rows (80gb) of position data (standard
object,timestamp,position,etc).
Every time I try to build some statistics by creating a table, such as:
> create table pos_stats1 as
> select id,year,month,count(1) from positions group by id,year,month;
I get an err
Albe Laurenz *EXTERN* wrote:
>
> stevesub wrote:
>> I keep having this need to create a function that will change the row
>> data
>> as I am walking through the data. For example, I process each row in
>> order,
>> if column1 change from previous row,
Hi,
I keep having this need to create a function that will change the row data
as I am walking through the data. For example, I process each row in order,
if column1 change from previous row, set column2 to true.
Is this possible? I can run another query to modify the data, but that
doesn't see
