Hi Charles,
Your example worked just fine.
Thank you.
-Original Message-
From: Charles Clavadetscher [mailto:clavadetsc...@swisspug.org]
Sent: Sunday, February 19, 2017 2:04 PM
To: 'Ertan Küçükoğlu' ;
pgsql-general@postgresql.org
Subject: RE: [GENERAL] Listing missing r
As suggested
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Ertan Küçükoglu
> Sent: Sonntag, 19. Februar 2017 11:27
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Listing missing
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')
Hello,
Using PostgreSQL 9.6.1 on a Windows 10 64bit, EnterpriseDB binaries.
I have following table:
CREATE TABLE report
(
id uuid NOT NULL,
no smallint NOT NULL,
serial character varying(15) NOT NULL,
branchcode character varying(10) NOT NULL,
date timestamp without time zone
