Changes

VC Database Rebuild (view source)

618 bytes added , 12:58, 20 July 2017

\COPY matcherportcomas FROM 'matcheroutputportco-mas.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV

--9645

Select the portco keys that are matched to the minimum announceddate for any mergers:

DROP TABLE matcherwarningmindates;

CREATE TABLE matcherwarningmindates AS

SELECT file1coname, file1statecode, file1datefirstinv, MIN(file2announceddate)

FROM matcherportcomas

WHERE excludeflag1 = 0 AND excludeflag2 = 0 AND warningflag = 1

GROUP BY file1coname, file1statecode, file1datefirstinv;

Find the keys that slipped through.

SELECT *, COUNT(*) FROM

(SELECT file1coname, file1statecode, file1datefirstinv FROM matcherportcomasinclude)a

GROUP BY file1coname, file1statecode, file1datefirstinv

HAVING COUNT(*) > 1;

file1coname | file1statecode | file1datefirstinv | count

220

edits