Postgres Pro
Downloads
Home   >   mailing lists

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

From Begin Daniel
Subject Re: Merging timeseries in postgres
Date
Msg-id CY1PR10MB04742418B7BE0C7B31BABE6294320@CY1PR10MB0474.namprd10.prod.outlook.com
Whole thread Raw
In response to Re: Merging timeseries in postgres  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Merging timeseries in postgres
List pgsql-general
Tree view

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@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 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.

​

Look at the above documentation (7.2.1.1) on full join

https://www.postgresql.org/docs/9.3/static/queries-table-expressions.html

 

select coalesce(dx,dx1)as dt, n, nx1

from test full join test1 on dx=dx1;

 

Daniel

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Strange array_to_table / unnest result
Next
From: "Day, David"
Date:
Subject: Server side backend permanent session memory usage ?