From: Thorsten Glaser <tg@evolvis.org>
To: pgsql-general@postgresql.org
Subject: Re: Window function for get the last value to extend missing rows
Date: Fri, 12 May 2023 20:14:18 +0200 (CEST)
Message-ID: <5a928693-d243-ef3b-7e2f-13e8c51ab688@evolvis.org> (raw)
In-Reply-To: <CAFePLY3qqWwvLPo9iBh3wyoU9i9L6WEEhWm37YaM0gLYAwvstA@mail.gmail.com>
References: <CAEcMXhmU=tzxhnHot2+5kYffBKJgjyvUtiK73wguSk4TsFNp1g@mail.gmail.com>
<CAFePLY3qqWwvLPo9iBh3wyoU9i9L6WEEhWm37YaM0gLYAwvstA@mail.gmail.com>
On Fri, 12 May 2023, GF wrote:
>"The SQL standard defines a RESPECT NULLS or IGNORE NULLS option for lead,
>lag, first_value, last_value, and nth_value. This is not implemented in
>PostgreSQL: the behavior is always the same as the standard's default,
>namely RESPECT NULLS".
Yeah, THAT caused no small amount of cursing, earlier this year,
I’d have also used IGNORE NULLS somewhere…
bye,
//mirabilos
--
15:41⎜<Lo-lan-do:#fusionforge> Somebody write a testsuite for helloworld :-)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: tg@evolvis.org
Subject: Re: Window function for get the last value to extend missing rows
In-Reply-To: <5a928693-d243-ef3b-7e2f-13e8c51ab688@evolvis.org>
References: <CAEcMXhmU=tzxhnHot2+5kYffBKJgjyvUtiK73wguSk4TsFNp1g@mail.gmail.com> <CAFePLY3qqWwvLPo9iBh3wyoU9i9L6WEEhWm37YaM0gLYAwvstA@mail.gmail.com> <5a928693-d243-ef3b-7e2f-13e8c51ab688@evolvis.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox