Re: Listing missing records

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Listing missing records
Date: 2017-02-19 10:43:47
Message-ID: 3aa475b4-42c2-d593-b201-6c1f45dd1eb5@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Charles Clavadetscher 2017-02-19 11:03:44 Re: Listing missing records
Previous Message Ertan Küçükoğlu 2017-02-19 10:26:36 Listing missing records