Esetleg összefűzni az egy percen belüli logbejegyzéseket?SELECT min_date,
listagg(b.log, chr(10)||chr(13)) within group (order by rn) log_list
FROM (
SELECT a.date min_date,
row_number() over (group by a.date order by b.date) rn,
b.*
FROM table a
JOIN table b
ON b.date >= a.date
AND b.date <= a.date + interval '1' minute)
GROUP BY min_date
ORDER BY min_date;
(Nem tudom, hogy néz ki a listagg postgresql megfelelője.)
Hello IT! Have you tried turning it off and on again?
