Re: Move from MySQL to PostgreSQL - Mailing list pgsql-general

basti schrieb am 29.03.2023 um 14:57:
> https://github.com/volkszaehler/volkszaehler.org/blob/master/lib/Util/Aggregation.php
>
> There are several problems.
>
> One of that ist the 'REPLACE INTO'.

Most probably INSERT ... ON CONFLICT

> An other problem is '@prev_timestamp := timestamp'

That's typically done with the lag() window function. No need for query variables.