pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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 :-)





view thread (6+ messages)  latest in thread

Message-ID: <5a928693-d243-ef3b-7e2f-13e8c51ab688@evolvis.org>
Permalink:  ../5a928693-d243-ef3b-7e2f-13e8c51ab688@evolvis.org/
Also on:    postgresql.org/message-id/5a928693-d243-ef3b-7e2f-13e8c51ab688@evolvis.org

 · 

reply

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