| From: | Begin Daniel <jfd553(at)hotmail(dot)com> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, 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 13:17:59 |
| Message-ID: | CY1PR10MB04742418B7BE0C7B31BABE6294320@CY1PR10MB0474.namprd10.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)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(at)cobra(dot)ru<mailto: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.
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Day, David | 2016-07-14 13:43:35 | Server side backend permanent session memory usage ? |
| Previous Message | Pavel Stehule | 2016-07-14 13:02:11 | Re: Strange array_to_table / unnest result |