<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.19258"></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=860245713-29082012>Didi you simply try to change type on the fly ?
Something like should work</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=860245713-29082012></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=860245713-29082012><FONT color=#000000 size=3
face="Times New Roman">st_estimated_extent('public',
geometry_columns.f_table_name, geometry_columns.f_geometry_column)::geometry AS
extent</FONT></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#000000 size=3 face="Times New Roman"><SPAN
class=860245713-29082012></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=860245713-29082012>Hugues.</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV align=left><FONT size=2 face=Arial></FONT> </DIV><BR>
<DIV dir=ltr lang=fr class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>De :</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>De la part de</B> Dale
Rudrum<BR><B>Envoyé :</B> mercredi 29 août 2012 15:55<BR><B>À :</B>
postgis-users@postgis.refractions.net<BR><B>Objet :</B> [postgis-users]
change column type in view<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>To have an easy and quick acces to the various projects we have had over
the years I would like to have a table with in it polygons representing the
areas in which work was done. It seems to me that a view would be easiest as
this is updated automatically. I came up with this script:</DIV>
<DIV></DIV>
<DIV>CREATE OR REPLACE VIEW project_overview AS <BR>SELECT
geometry_columns.f_table_name AS table, geometry_columns.f_geometry_column AS
geometrycol, st_estimated_extent('public', geometry_columns.f_table_name,
geometry_columns.f_geometry_column) AS extent<BR>FROM geometry_columns<BR>WHERE
geometry_columns.f_table_name::text <> 'project_overview';</DIV>
<DIV></DIV>
<DIV>which works fine, save that the type of the column extent is not geometry.
Therefore autocad and quantum GIS cannot acces the information</DIV>
<DIV>Is there a way to change this in the definition of the view, or to bypass
the problem by using a second view? As a newby I'm stuck at this
point.</DIV>
<DIV>Also suggestions for different setups solving my problem would be
appreciated. Because of our use of autocad we are restricted to PostGIS 1.5 on
postgres 9.0.</DIV>
<DIV></DIV>
<DIV>Thanks</DIV>
<DIV>Dale Rudrum</DIV></BODY></HTML>