Re: Interpolatioin problem - pg 12.4

2020-08-19 Thread Pól Ua Laoínecháin
HI all, Sorry - posted the wrong URL for my problem - Doh... Here is the correct one! https://dbfiddle.uk/?rdbms=postgres_12&fiddle=428aa76d49b37961088d3dfef190757f Again, apologies and rgs, Pól... On Wed, 19 Aug 2020 at 19:16, Pól Ua Laoínecháin wrote: > > Hi all, > > I have an interpola

Interpolatioin problem - pg 12.4

2020-08-19 Thread Pól Ua Laoínecháin
Hi all, I have an interpolation problem as follows - fiddle available here: https://dbfiddle.uk/?rdbms=postgres_12&fiddle=8d23925146ea11a904c454709b0026fd A table: CREATE TABLE data ( s SERIAL PRIMARY KEY, t TIMESTAMP, lat NUMERIC ); and data: INSERT INTO data (t, lat) VALUES ('2019-01