Postgres Pro
Downloads
Home   >   mailing lists

Re: Window function for get the last value to extend missing rows - Mailing list pgsql-general

From postmaster@heinz-it.de
Subject Re: Window function for get the last value to extend missing rows
Date
Msg-id d4a7f253-3ad7-efb5-b788-0ff740bb512f@heinz-it.de
Whole thread Raw
In response to Window function for get the last value to extend missing rows  (Durumdara <durumdara@gmail.com>)
List pgsql-general
Tree view 
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?

pgsql-general by date:

Previous
From: Marc Millas
Date:
Subject: Re: order by
Next
From: Ron
Date:
Subject: Re: Adding SHOW CREATE TABLE