Re: Merging timeseries in postgres

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Nick Babadzhanian <nb(at)cobra(dot)ru>
Cc: Tim Smith <randomdev4+postgres(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Merging timeseries in postgres
Date: 2016-07-14 12:23:09
Message-ID: CAKFQuwbF-Xjb=bMzDZnaVZgap=zcOoWU=2OEy4oFab3=Z4xE7g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jul 14, 2016 at 8:18 AM, Nick Babadzhanian <nb(at)cobra(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Devrim Gündüz 2016-07-14 12:49:40 Re: postgresql "init script" for postgres 9.2.15
Previous Message Nick Babadzhanian 2016-07-14 12:22:56 Re: Merging timeseries in postgres