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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
