On Tue, 18 Jul 2023 at 06:19, basti <mailinglist(at)unix-solution(dot)de> wrote:
>
> Thanks a lot tomas, i will try it.
>
> I have find out that there is a 'aggregation' function in the frontend.
> But this is MySQL specific and I have no idea the transform it to postgres.
>
> It looks like:
> 'REPLACE INTO aggregate (channel_id, type, timestamp, value, count)
Perhaps that's something like PostgreSQL's INSERT ON CONFLICT [1]
David
[1] https://www.postgresql.org/docs/current/sql-insert.html