Re: Move from MySQL to PostgreSQL

2023-03-29 Thread Thomas Kellerer
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 t

Move from MySQL to PostgreSQL

2023-03-29 Thread basti
Hello, I try to move from MySQL to PostgreSQL. All seems to work expect of one query. The query is part of https://github.com/volkszaehler/volkszaehler.org https://github.com/volkszaehler/volkszaehler.org/blob/master/lib/Util/Aggregation.php There are several problems. One of that ist the