Postgres Pro
Downloads
Home   >   mailing lists

Re: Merging timeseries in postgres - Mailing list pgsql-general

From David G. Johnston
Subject Re: Merging timeseries in postgres
Date
Msg-id CAKFQuwY1Y=oFM_xTBvLZi-q5HjnN3zLpyV19Hrn3OMGrG-NrjA@mail.gmail.com
Whole thread Raw
In response to Merging timeseries in postgres  (Tim Smith <randomdev4+postgres@gmail.com>)
List pgsql-general
Tree view
On Thu, Jul 14, 2016 at 7:56 AM, Tim Smith <randomdev4+postgres@gmail.com> 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.


pgsql-general by date:

Previous
From: Tim Smith
Date:
Subject: Merging timeseries in postgres
Next
From: Nick Babadzhanian
Date:
Subject: Re: Merging timeseries in postgres