Re: [GENERAL] Listing missing records - Mailing list pgsql-general

From John R Pierce
Subject Re: [GENERAL] Listing missing records
Date
Msg-id 3aa475b4-42c2-d593-b201-6c1f45dd1eb5@hogranch.com
Whole thread Raw
In response to [GENERAL] Listing missing records  (Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>)
List pgsql-general
On 2/19/2017 2:26 AM, Ertan Küçükoğlu wrote:
> What I am looking for is a list of serial, branchcode , date columns just
> for the missing days.

so are there other tables with all the valid serial, branchcode values ?

finding missing values generally revolves around doing an anti-join
('NOT IN') with generate_series.


--
john r pierce, recycling bits in santa cruz



pgsql-general by date:

Previous
From: Ertan Küçükoğlu
Date:
Subject: [GENERAL] Listing missing records
Next
From: "Charles Clavadetscher"
Date:
Subject: Re: [GENERAL] Listing missing records