Re: [GENERAL] Merging timeseries in postgres

2016-07-15 Thread Tim Smith
o:* Nick Babadzhanian > *Cc:* Tim Smith; pgsql-general > *Subject:* Re: [GENERAL] Merging timeseries in postgres > > > > On Thu, Jul 14, 2016 at 8:18 AM, Nick Babadzhanian <n...@cobra.ru > <javascript:_e(%7B%7D,'cvml','n...@cobra.ru');>> wrote: > > Whats exactly

Re: [GENERAL] Merging timeseries in postgres

2016-07-14 Thread Begin Daniel
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of David G. Johnston Sent: Thursday, 14 July, 2016 08:23 To: Nick Babadzhanian Cc: Tim Smith; pgsql-general Subject: Re: [GENERAL] Merging timeseries in postgres On Thu, Jul 14, 2016 at 8:18 AM, Nick

Re: [GENERAL] Merging timeseries in postgres

2016-07-14 Thread David G. Johnston
On Thu, Jul 14, 2016 at 8:18 AM, Nick Babadzhanian wrote: > Whats exactly is wrong with the following query? > > select > dx date, > nx, > nx1 > from > test t > join test1 t1 on t.dx=t1.dx1 > ; > > ​Please don't top-post. test t

Re: [GENERAL] Merging timeseries in postgres

2016-07-14 Thread Nick Babadzhanian
Message - From: "Tim Smith" <randomdev4+postg...@gmail.com> To: "pgsql-general" <pgsql-general@postgresql.org> Sent: Thursday, July 14, 2016 2:56:19 PM Subject: [GENERAL] Merging timeseries in postgres Hi, I've got a bit of query-writers block ! I've tried v

Re: [GENERAL] Merging timeseries in postgres

2016-07-14 Thread Nick Babadzhanian
;pgsql-general@postgresql.org> Sent: Thursday, July 14, 2016 2:56:19 PM Subject: [GENERAL] Merging timeseries in postgres Hi, I've got a bit of query-writers block ! I've tried various join styles but can't get it to do what I want to achieve. Assume I have a bunch of time-series tables : cre

Re: [GENERAL] Merging timeseries in postgres

2016-07-14 Thread David G. Johnston
On Thu, Jul 14, 2016 at 7:56 AM, Tim Smith wrote: > > 2003-01-03 (null) 0.003 ​Where​ did the "0.003" come from? The result you are looking for works if you full outer join on dx1 - at least for the sample data. David J.

[GENERAL] Merging timeseries in postgres

2016-07-14 Thread Tim Smith
Hi, I've got a bit of query-writers block ! I've tried various join styles but can't get it to do what I want to achieve. Assume I have a bunch of time-series tables : create table test(dx date,n numeric); create table test1(dx1 date,nx1 numeric); insert into test values('2000-01-01','0.001');