[postgis-devel] [PostGIS] #1765: Incorrect ST_Extent example in README_Raster.txt

[PostGIS]

#1765: Incorrect ST_Extent example in README_Raster.txt
---------------------------+------------------------------------------------
 Reporter:  mloskot        |       Owner:  robe          
     Type:  defect         |      Status:  new           
 Priority:  medium         |   Milestone:  PostGIS Future
Component:  documentation  |     Version:  2.0.x         
 Keywords:  extent         |  
---------------------------+------------------------------------------------
 Using PostgreSQL 9.1 x86 on Windows 7

 {{{
 SELECT postgis_raster_lib_build_date(), postgis_raster_lib_version();

 "2012-04-03 23:11:11";"2.0.0 r9605"
 }}}

 [http://postgis.org/download/windows/ README_Raster.txt] includes the
 following SQL:

 {{{
 SELECT ST_Extent(rast) FROM rt_test
 }}}

 which obviously leads to

 {{{
 ERROR:  function st_extent(raster) does not exist
 LINE 1: SELECT ST_Extent(rast) FROM rt_test
                ^
 HINT:  No function matches the given name and argument types. You might
 need to add explicit type casts.
 }}}

 Apparently, correct command should read

 {{{
 SELECT ST_Extent(rast::geometry) FROM rt_test
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1765>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.