1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
---------------------------------------------------------------------
-- Core function to access the PAGC address standardizer
-- Author: Stephen Woodbridge <woodbri@imaptools.com>
---------------------------------------------------------------------
CREATE OR REPLACE FUNCTION standardize_address(
lextab text,
gaztab text,
rultab text,
micro text,
macro text )
RETURNS stdaddr
AS 'MODULE_PATHNAME', 'standardize_address'
LANGUAGE 'c' IMMUTABLE STRICT COST 200;
CREATE OR REPLACE FUNCTION standardize_address(
lextab text,
gaztab text,
rultab text,
address text )
RETURNS stdaddr
AS 'MODULE_PATHNAME', 'standardize_address1'
LANGUAGE 'c' IMMUTABLE STRICT COST 200;
CREATE OR REPLACE FUNCTION parse_address(IN text,
OUT num text,
OUT street text,
OUT street2 text,
OUT address1 text,
OUT city text,
OUT state text,
OUT zip text,
OUT zipplus text,
OUT country text)
RETURNS record
AS 'MODULE_PATHNAME', 'parse_address'
LANGUAGE 'c' IMMUTABLE STRICT;
|
