<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7601.17573"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=407375820-28042011><FONT color=#0000ff
size=2 face=Arial>Jonathan,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=407375820-28042011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=407375820-28042011><FONT color=#0000ff
size=2 face=Arial>Sorry about that. My fault. I accidentally
commented something out not intending to.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=407375820-28042011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=407375820-28042011><FONT color=#0000ff
size=2 face=Arial>The second function in that file should be</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=407375820-28042011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=407375820-28042011><FONT color=#0000ff
size=2 face=Arial>CREATE OR REPLACE FUNCTION reverse_geocode(IN pt geometry, OUT
intpt geometry[],<BR> OUT addy
NORM_ADDY[],<BR> OUT street varchar[]) RETURNS RECORD<BR>AS
<BR>$$<BR>-- default to not including street range in cross
streets<BR> SELECT
reverse_geocode($1,false);<BR>$$<BR>language sql STABLE;</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=407375820-28042011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=407375820-28042011><FONT color=#0000ff
size=2 face=Arial>I'll patch this in subversion.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=407375820-28042011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=407375820-28042011><FONT color=#0000ff
size=2 face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=407375820-28042011><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=407375820-28042011><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV><FONT
color=#0000ff size=2 face=Arial></FONT><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Johnathan Leppert<BR><B>Sent:</B> Thursday, April 28, 2011 4:14
PM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> Re: [postgis-users]
Geocoder (from extras)<BR></FONT><BR></DIV>
<DIV></DIV>Yes I do, but my problem occurs when running the SQL to install the
various functions into that schema. I had to comment out
geocode/reverse_geocode.
<DIV id=:qg>sql (which is included as part of create_geocode.sql) in order for
the rest to install successfully.<BR><BR>There appears to be a syntax error with
the reverse_geocode function:<BR><BR>psql:geocode/reverse_geocode.
<DIV id=:qg>sql:101: ERROR: return type mismatch in function declared to
return record<BR>DETAIL: Function's final statement must be SELECT or
INSERT/UPDATE/DELETE RETURNING.<BR>CONTEXT: SQL function
"reverse_geocode"<BR><BR>I'm not too familiar with writing them, so I'm not able
to stop/debug the error. Any
ideas?<BR><BR>Thanks,<BR><BR>Johnathan<BR></DIV></DIV><BR><BR>
<DIV class=gmail_quote>On Thu, Apr 28, 2011 at 4:09 PM, Paragon Corporation
<SPAN dir=ltr><<A href="mailto:lr@pcorp.us">lr@pcorp.us</A>></SPAN>
wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2 face=Arial>All the
functions should have been installed in tiger schema.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2 face=Arial>Do you
have a tiger schema?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN></SPAN><SPAN></SPAN><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN>Leo</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN></SPAN></FONT><A
href="http://www.postgis.us" target=_blank><FONT
size=2>h<SPAN>ttp://www.postgis.us</SPAN></FONT></A></FONT></FONT><BR></DIV>
<DIV dir=ltr lang=en-us align=left>
<HR>
<FONT size=2 face=Tahoma><B>From:</B> <A
href="mailto:postgis-users-bounces@postgis.refractions.net"
target=_blank>postgis-users-bounces@postgis.refractions.net</A> [mailto:<A
href="mailto:postgis-users-bounces@postgis.refractions.net"
target=_blank>postgis-users-bounces@postgis.refractions.net</A>] <B>On Behalf
Of </B>Johnathan Leppert<BR><B>Sent:</B> Thursday, April 28, 2011 10:39
AM<BR><B>To:</B> <A href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.refractions.net</A><BR><B>Subject:</B>
[postgis-users] Geocoder (from extras)<BR></FONT><BR></DIV>
<DIV>
<DIV></DIV>
<DIV class=h5>
<DIV></DIV>I fixed several bugs in the generated bash script to import US
Census shapefiles. Now I'm having an issue with the reverse geocoder
SQL:<BR><BR>postgres@li63-206:/tmp/tiger_2010$ /usr/local/pgsql/bin/psql -d
geo -f ./create_geocode.sql<BR>psql:./create_geocode.sql:4: ERROR:
schema "tiger" does not exist<BR>BEGIN<BR>psql:./create_geocode.sql:7:
NOTICE: type "norm_addy" does not exist, skipping<BR>DROP TYPE<BR>CREATE
TYPE<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE
FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE
FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE
FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE
FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE
FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE
FUNCTION<BR>CREATE FUNCTION<BR>CREATE FUNCTION<BR>CREATE
FUNCTION<BR>psql:geocode/reverse_geocode.sql:101: ERROR: return type
mismatch in function declared to return record<BR>DETAIL: Function's
final statement must be SELECT or INSERT/UPDATE/DELETE
RETURNING.<BR>CONTEXT: SQL function
"reverse_geocode"<BR>ROLLBACK<BR><BR>Anyone have any ideas? Using
postgis-2.0.0SVN<BR><BR>Thanks,<BR><BR>Johnathan<BR></DIV></DIV></DIV><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR><BR></BLOCKQUOTE></DIV><BR><BR
clear=all><BR>-- <BR><I><FONT color=#cccccc>Johnathan</FONT></I>
<DIV><FONT color=#cccccc>Software Architect & Developer</FONT></DIV>
<DIV><FONT color=#cccccc>Columbus, Ohio</FONT></DIV>
<DIV><I><FONT color=#cccccc><A href="http://twitter.com/#%21/iamleppert"
target=_blank>Follow me on Twitter:
@iamleppert</A></FONT></I></DIV><BR></BODY></HTML>