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
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
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
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
;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
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.
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');