Am 23.09.23 um 20:56 schrieb Chris Kelly:
On Ubuntu "18.04.6 LTS (Bionic Beaver)":
# apt-cache search pgsql | grep 8
pike7.8-pg - PostgreSQL modules for Pike
pike8.0-pg - PostgreSQL modules for Pike
# apt-cache search pgsql | grep php
php-pgsql - PostgreSQL module for PHP [default]
php7.2-pg
Am 12.05.23 um 13:04 schrieb Durumdara:
[...]
The LAG function seems to be ok, but how to handle if more than two periods
are missing?
03:00 10
03:01 NULL
03:02 NULL
03:03 NULL
03:04 11
03:05 13
[...]
and how do you think about NULL in first(and second/third) row?