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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
