329
edits
Changes
Jump to navigation
Jump to search
→A Stopgap Measure
GodHelpUsAll(postcode_cleaned, postcode) as postcode
FROM ptoassigneend_us_cleaned;</nowiki>
<nowiki>
patent=# select count(*) from june_2017_zipcode_hotfix ;
count
---------
3572605
(1 row)
-- NOTE THAT THE DEFAULT BEHAVIOR OF THE SCRIPT IS TO FALL BACK TO THE EMPTY QUOTE
-- AND NOT NULL AS BEFORE
patent=# select count(*) from june_2017_zipcode_hotfix where postcode != '';
count
---------
3370613
(1 row)</nowiki>
