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