X-Git-Url: https://git.8kb.co.uk/?p=postgresql%2Fgeographic_data;a=blobdiff_plain;f=os_postgresql_import.plpgsql;h=cb15a30f006495635381613971f24a3dfb57ddc0;hp=8b7dd19e5b6995ea54e692cedfd62ab65041b4d1;hb=6bcf4ac235f27bc6a4c0e3f69aac134fda8e331b;hpb=dbe06233a9220029439c5baa17ebc83eb52d457e

diff --git a/os_postgresql_import.plpgsql b/os_postgresql_import.plpgsql
index 8b7dd19..cb15a30 100644
--- a/os_postgresql_import.plpgsql
+++ b/os_postgresql_import.plpgsql
@@ -101,8 +101,8 @@ BEGIN
 	INSERT INTO public.pc_opendata_areas (code, type, description) VALUES ('S92000003', 'CNY', 'Scotland');
 	INSERT INTO public.pc_opendata_areas (code, type, description) VALUES ('E05008322', 'DIW', 'Bryher Ward');
 	INSERT INTO public.pc_opendata_areas (code, type, description) VALUES ('E05008323', 'DIW', 'St. Agnes Ward');
-	INSERT INTO public.pc_opendata_areas (code, type, description) VALUES ('E05008324', 'DIW', 'St. Martin\'s Ward');
-	INSERT INTO public.pc_opendata_areas (code, type, description) VALUES ('E05008325', 'DIW', 'St. Mary\'s Ward');
+	INSERT INTO public.pc_opendata_areas (code, type, description) VALUES ('E05008324', 'DIW', E'St. Martin\'s Ward');
+	INSERT INTO public.pc_opendata_areas (code, type, description) VALUES ('E05008325', 'DIW', E'St. Mary\'s Ward');
 	INSERT INTO public.pc_opendata_areas (code, type, description) VALUES ('E05008326', 'DIW', 'Tresco Ward');
 	
 	-- Finally our postcode data
@@ -212,8 +212,8 @@ BEGIN
 	INSERT INTO tmp_pc_opendata_areas (code, type, description) VALUES ('S92000003', 'CNY', 'Scotland');
 	INSERT INTO tmp_pc_opendata_areas (code, type, description) VALUES ('E05008322', 'DIW', 'Bryher Ward');
 	INSERT INTO tmp_pc_opendata_areas (code, type, description) VALUES ('E05008323', 'DIW', 'St. Agnes Ward');
-	INSERT INTO tmp_pc_opendata_areas (code, type, description) VALUES ('E05008324', 'DIW', 'St. Martin\'s Ward');
-	INSERT INTO tmp_pc_opendata_areas (code, type, description) VALUES ('E05008325', 'DIW', 'St. Mary\'s Ward');
+	INSERT INTO tmp_pc_opendata_areas (code, type, description) VALUES ('E05008324', 'DIW', E'St. Martin\'s Ward');
+	INSERT INTO tmp_pc_opendata_areas (code, type, description) VALUES ('E05008325', 'DIW', E'St. Mary\'s Ward');
 	INSERT INTO tmp_pc_opendata_areas (code, type, description) VALUES ('E05008326', 'DIW', 'Tresco Ward');
 	
 	-- Finally our postcode data
@@ -243,4 +243,4 @@ BEGIN
 END;
 
 $BODY$
-LANGUAGE 'plpgsql' VOLATILE;
\ No newline at end of file
+LANGUAGE 'plpgsql' VOLATILE;