From 4d270f784912bf54f76adb0cc1e30f752e038a4d Mon Sep 17 00:00:00 2001 From: Sandro Santilli Date: Mon, 21 Mar 2005 12:24:31 +0000 Subject: [PATCH] Expanded estimated_extent() paragraph to document differences between pre and post pgsql 800. git-svn-id: http://svn.osgeo.org/postgis/trunk@1551 b70326c6-7e19-0410-871a-916f4a2858ee --- doc/postgis.xml | 18 ++++++++++-------- 1 file changed, 10 insertions(+), 8 deletions(-) diff --git a/doc/postgis.xml b/doc/postgis.xml index bec1db92e..37c269d7c 100644 --- a/doc/postgis.xml +++ b/doc/postgis.xml @@ -4401,15 +4401,17 @@ FROM geometry_table; - - estimated_extent([schema], table, geocolumn) - - Return the 'estimated' extent of the given spatial table. The estimated is taken from the geometry column's statistics gathered by running VACUUM ANALYZE, and is statistically about 95% of 'real' extent. The current schema will be used if not specified. - NOTE: This is only available with PostgreSQL >= 8.0.0 - - + + estimated_extent([schema], table, geocolumn) + + Return the 'estimated' extent of the given spatial table. The estimated is taken from the geometry column's statistics. The current schema will be used if not specified. - + For PostgreSQL>=8.0.0 statistics are gathered by VACUUM ANALYZE and resulting extent will be about 95% of the real one. + For PostgreSQL<8.0.0 statistics are gathered by update_geometry_stats() and resulting extent will be exact. + + + + find_srid(varchar,varchar,varchar) -- 2.40.0