Re: Interpolation problem - pg 12.4 - full correct version!

Hi, > Might want to consider using PL/R with something like the R imputeTS package: > https://cran.r-project.org/web/packages/imputeTS/readme/README.html Thanks for your input - looks interesting, but see my reply to David Johnston. Rgs, Pól > Joe

Re: Interpolation problem - pg 12.4 - full correct version!

Hi, >> So, my question is: Is there a recognised technique (using SQL only, >> not PL/pgSQL - soutions based on the latter are easy to find) whereby >> I can do a basic Linear Interpolation? > I don't have a recognized technique, nor care to ponder one right now, but > what you've described

Re: Interpolation problem - pg 12.4 - full correct version!

On 8/19/20 3:08 PM, David G. Johnston wrote: > On Wed, Aug 19, 2020 at 11:51 AM Pól Ua Laoínecháin > wrote: > > > I think my *MAJOR* problem is that I've developed what is, > essentially, a totally brute force approach - and this simply won't > work at the

Re: Interpolation problem - pg 12.4 - full correct version!

On Wed, Aug 19, 2020 at 11:51 AM Pól Ua Laoínecháin wrote: > > I think my *MAJOR* problem is that I've developed what is, > essentially, a totally brute force approach - and this simply won't > work at the scenario becomes more complex - take a look at the CASE > statement - it's horrible and

Interpolation problem - pg 12.4 - full correct version!

Hi all - here is the entire correct problem - apologies again! Hi all, I have an interpolation problem as follows - fiddle available here: https://dbfiddle.uk/?rdbms=postgres_12=428aa76d49b37961088d3dfef190757f A table: CREATE TABLE data ( s SERIAL PRIMARY KEY, t TIMESTAMP, lat NUMERIC