Re: Need help with upsert

Le mercredi 04 décembre 2013 à 17:48 +0000, Eric Lamer a écrit :

>
>
> Each day I want to copy the last 7 days into one table so I have one
> table with the last 7 days of logs.
>
>
>
> So I want to copy the data from 7 tables into 1. If the row does
> not exist I just insert and if the row already exist I just update the
> sum (existing sum + new sum).
>

Unless you have a specific reason not to, ISTM you could make your life
_much_ easier with just one table and a date column?

>
>
> Public.test is the table I use for the last 7 days logs.
>
> daily.daily_20131202 is table for 1 day.
>
> I will run this command 7 times with different daily table.
>

> Also, is there an easier way to do that?
>

I would just insert all rows into one big table with a date field, and
then make a select count() with the appropriate where clause on the date
field and group by clause.

--
Salutations, Vincent Veyron

Legal cases, contracts and insurance claims management
http://libremen.com