File: geocode_get_point.sql

package info (click to toggle)
postgis 1.3.3-3
  • links: PTS, VCS
  • area: main
  • in suites: lenny
  • size: 10,468 kB
  • ctags: 4,310
  • sloc: sql: 73,321; ansic: 35,513; xml: 6,160; java: 6,061; sh: 3,428; perl: 1,447; cpp: 987; makefile: 727; yacc: 276; python: 192
file content (10 lines) | stat: -rw-r--r-- 191 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
 
CREATE OR REPLACE FUNCTION geocode_get_point(VARCHAR) RETURNS GEOMETRY
AS $_$
DECLARE
  ans RECORD;
BEGIN
  ans := geocode(NULL, $1);

  RETURN centroid(ans.geom);
END;
$_$ LANGUAGE plpgsql;