Revision 13813
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 2962 | 2962 |
|
| 2963 | 2963 |
|
| 2964 | 2964 |
-- |
| 2965 |
-- Name: point(double precision, double precision); Type: FUNCTION; Schema: util; Owner: - |
|
| 2966 |
-- |
|
| 2967 |
|
|
| 2968 |
CREATE FUNCTION point(latitude_deg double precision, longitude_deg double precision) RETURNS postgis.geography |
|
| 2969 |
LANGUAGE sql IMMUTABLE |
|
| 2970 |
AS $_$ |
|
| 2971 |
SELECT postgis.st_setsrid(postgis.st_point(/*x_lon=*/$2, /*y_lat=*/$1), |
|
| 2972 |
/*WGS84*/4326)::postgis.geography |
|
| 2973 |
$_$; |
|
| 2974 |
|
|
| 2975 |
|
|
| 2976 |
-- |
|
| 2965 | 2977 |
-- Name: populate_table(regclass, text); Type: FUNCTION; Schema: util; Owner: - |
| 2966 | 2978 |
-- |
| 2967 | 2979 |
|
Also available in: Unified diff
schemas/util.sql: added point()