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

From David G. Johnston
Subject Re: Merging timeseries in postgres
Date
Msg-id CAKFQuwbF-Xjb=bMzDZnaVZgap=zcOoWU=2OEy4oFab3=Z4xE7g@mail.gmail.com
Whole thread Raw
In response to Re: Merging timeseries in postgres  (Nick Babadzhanian <nb@cobra.ru>)
Responses Re: Merging timeseries in postgres  (Begin Daniel <jfd553@hotmail.com>)
List pgsql-general
On Thu, Jul 14, 2016 at 8:18 AM, Nick Babadzhanian <nb@cobra.ru> 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 join test1 t1 -- this is the default inner join, your query returns no records for the given data.

David J.
 

pgsql-general by date:

Previous
From: Nick Babadzhanian
Date:
Subject: Re: Merging timeseries in postgres
Next
From: Devrim Gündüz
Date:
Subject: Re: postgresql "init script" for postgres 9.2.15