From 95c3bb5115fa303784db422c40549bd93a99f995 Mon Sep 17 00:00:00 2001
From: Regina Obe <lr@pcorp.us>
Date: Tue, 17 May 2011 22:50:27 +0000
Subject: [PATCH] Nothing like experimenting with myself.  Change ST_AsX3D to
 use default parameters and reduce down to one proto

git-svn-id: http://svn.osgeo.org/postgis/trunk@7177 b70326c6-7e19-0410-871a-916f4a2858ee
---
 doc/reference_output.xml      | 6 +-----
 postgis/postgis.sql.in.c      | 9 ++-------
 postgis/postgis_drop.sql.in.c | 3 +--
 3 files changed, 4 insertions(+), 14 deletions(-)

diff --git a/doc/reference_output.xml b/doc/reference_output.xml
index 32544e398..a52c454a7 100644
--- a/doc/reference_output.xml
+++ b/doc/reference_output.xml
@@ -859,11 +859,7 @@ SELECT ST_AsGML(3, ST_GeomFromEWKT('POLYHEDRALSURFACE( ((0 0 0, 0 0 1, 0 1 1, 0
 			<funcprototype>
 				<funcdef>text <function>ST_AsX3D</function></funcdef>
 				<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>
-			</funcprototype>
-			<funcprototype>
-				<funcdef>text <function>ST_AsX3D</function></funcdef>
-				<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>
-				<paramdef><type>integer </type> <parameter>prec</parameter></paramdef>
+				<paramdef choice="opt"><type>integer </type> <parameter>prec</parameter></paramdef>
 			</funcprototype>
 		</funcsynopsis>
 	  </refsynopsisdiv>
diff --git a/postgis/postgis.sql.in.c b/postgis/postgis.sql.in.c
index 20c4663ff..663a306f4 100644
--- a/postgis/postgis.sql.in.c
+++ b/postgis/postgis.sql.in.c
@@ -5271,16 +5271,11 @@ CREATE OR REPLACE FUNCTION _ST_AsX3D(int4, geometry, int4, int4, text)
 	LANGUAGE 'C' IMMUTABLE;
 	
 -- ST_AsX3D(geom, precision)
-CREATE OR REPLACE FUNCTION ST_AsX3D(geom geometry, prec int4)
+CREATE OR REPLACE FUNCTION ST_AsX3D(geom geometry, prec integer DEFAULT 15)
 	RETURNS TEXT
 	AS $$SELECT _ST_AsX3D(3,$1,$2,1,'');$$
 	LANGUAGE 'sql' IMMUTABLE;
-	
--- ST_AsX3D(geom, precision)
-CREATE OR REPLACE FUNCTION ST_AsX3D(geom geometry)
-	RETURNS TEXT
-	AS $$SELECT _ST_AsX3D(3,$1,15,1,'');$$
-	LANGUAGE 'sql' IMMUTABLE;
+
 COMMIT;
 
 #include "postgis_drop.sql.in.c"
diff --git a/postgis/postgis_drop.sql.in.c b/postgis/postgis_drop.sql.in.c
index 11727f84d..273f366e4 100644
--- a/postgis/postgis_drop.sql.in.c
+++ b/postgis/postgis_drop.sql.in.c
@@ -14,6 +14,7 @@ DROP FUNCTION IF EXISTS box2d_contained(box2d, box2d);
 DROP FUNCTION IF EXISTS box2d_overlap(box2d, box2d);
 DROP FUNCTION IF EXISTS box2d_same(box2d, box2d);
 DROP FUNCTION IF EXISTS box2d_intersects(box2d, box2d);
+DROP FUNCTION IF EXISTS st_asx3d(geometry); -- this one changed to use default parameters so full function deals with it
 DROP FUNCTION IF EXISTS st_box2d_overleft(box2d, box2d);
 DROP FUNCTION IF EXISTS st_box2d_overright(box2d, box2d);
 DROP FUNCTION IF EXISTS st_box2d_left(box2d, box2d);
@@ -56,5 +57,3 @@ DROP FUNCTION IF EXISTS geosnoop(geometry);
 DROP FUNCTION IF EXISTS jtsnoop(geometry);
 DROP FUNCTION IF EXISTS st_noop(geometry);
 DROP FUNCTION IF EXISTS st_max_distance(geometry, geometry);
-
-
-- 
2.50.1