<div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Hello all.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Can you help me on the next:</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">I can create a materialized view like this to extract data from other tables within a polygon,</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">query:</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">create materialized view vm_adoquin as <br>select adoquin.gid,<a href="http://adoquin.id">adoquin.id</a>,adoquin.control,st_intersection(adoquin.geom, pol.geom) as geom <br>from  adoquin, municipio pol <br>where pol.municipio = 23  <br>and adoquin.geom && pol.geom <br>and ST_IsEmpty(ST_Intersection(adoquin.geom, pol.geom)) != TRUE;</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">the resulting materialized view has geom type GEOMETRY but I need the geom type as LINESTRING<br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">How I can cast the view if I know that geometrytype(st_intersection(autopista.geom, pol.geom))=LINESTRING</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">but can't use <br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">st_intersection(autopista.geom, pol.geom)::geometry(geometrytype(st_intersection(autopista.geom, pol.geom)), 32614) to cast because can't use functions in type conversions.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Thanks in advance.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Nahum<br clear="all"></div><br>-- <br><div class="gmail_signature"><div dir="ltr"><div><b>Nahum Castro González</b><br>Blvd. Perdigón 214, Brisas del Lago.<br>
CP 37207<br>
León, Guanajuato, México<br>
Tel (477)1950304<br></div>Cel (477)1274694<br></div></div>
</div>