Re: Window function for get the last value to extend missing rows

From: postmaster(at)heinz-it(dot)de
To: Durumdara <durumdara(at)gmail(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Window function for get the last value to extend missing rows
Date: 2023-05-13 17:06:11
Message-ID: d4a7f253-3ad7-efb5-b788-0ff740bb512f@heinz-it.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2023-05-13 18:28:11 Re: Adding SHOW CREATE TABLE
Previous Message Marc Millas 2023-05-13 16:56:53 Re: order by