From b69f7c369d746c0455da425f766a86cb50f8a02d Mon Sep 17 00:00:00 2001
From: Regina Obe <lr@pcorp.us>
Date: Wed, 10 Oct 2012 23:06:34 +0000
Subject: [PATCH] create norm_addy

git-svn-id: http://svn.osgeo.org/postgis/trunk@10397 b70326c6-7e19-0410-871a-916f4a2858ee
---
 .../sql_bits/norm_addy_create.sql.in                  | 11 +++++++++++
 1 file changed, 11 insertions(+)
 create mode 100644 extensions/postgis_tiger_geocoder/sql_bits/norm_addy_create.sql.in

diff --git a/extensions/postgis_tiger_geocoder/sql_bits/norm_addy_create.sql.in b/extensions/postgis_tiger_geocoder/sql_bits/norm_addy_create.sql.in
new file mode 100644
index 000000000..12df5b278
--- /dev/null
+++ b/extensions/postgis_tiger_geocoder/sql_bits/norm_addy_create.sql.in
@@ -0,0 +1,11 @@
+CREATE TYPE norm_addy AS (
+    address INTEGER,
+    preDirAbbrev VARCHAR,
+    streetName VARCHAR,
+    streetTypeAbbrev VARCHAR,
+    postDirAbbrev VARCHAR,
+    internal VARCHAR,
+    location VARCHAR,
+    stateAbbrev VARCHAR,
+    zip VARCHAR,
+    parsed BOOLEAN);
-- 
2.50.1