-- 7) Postzon with latlon generated using postgis
TRUNCATE TABLE data_stage;
- RAISE NOTICE '%: Begin staging postzone', clock_timestamp();
+ RAISE NOTICE '%: Begin staging postzon', clock_timestamp();
v_sql := 'COPY data_stage FROM ' || quote_literal(v_data_postzon || 'pzone100.c01');
EXECUTE v_sql;
EXECUTE v_sql;
DELETE FROM data_stage WHERE data like '%WCHANGES' || in_edition || '%' OR data like v_main_footer;
- RAISE NOTICE '%: Done staging WChanges2 file',clock_timestamp();
+ RAISE NOTICE '%: Done staging WChanges file',clock_timestamp();
RAISE NOTICE '%: Preparing to update welsh mainfile', clock_timestamp();
-- It would appear postzon is supplied as a full refresh rather than an update file
TRUNCATE TABLE data_stage;
- RAISE NOTICE '%: Begin staging postzone', clock_timestamp();
+ RAISE NOTICE '%: Begin staging postzon', clock_timestamp();
v_sql := 'COPY data_stage FROM ' || quote_literal(v_data_postzon || 'pzone100.c01');
EXECUTE v_sql;
LEFT OUTER JOIN public.pc_paf_organisations lo ON mw.address_key = lo.organisation_key AND mw.postcode_type = lo.postcode_type
LEFT OUTER JOIN public.pc_paf_postzon_100m p USING (outward_code, inward_code)
LEFT OUTER JOIN public.pc_paf_county_alias a ON a.postcode = (rpad(mw.outward_code,4) || mw.inward_code)
-LEFT OUTER JOIN public.pc_paf_counties apc ON apc.county_key = a.former_postal_county;
\ No newline at end of file
+LEFT OUTER JOIN public.pc_paf_counties apc ON apc.county_key = a.former_postal_county;