[postgis-devel] [PostGIS] #771: Unable to query if geometry column has mixed srid

[PostGIS]

#771: Unable to query if geometry column has mixed srid
---------------------------+------------------------------------------------
  Reporter:  farrukhnajmi  |       Owner:  pramsey      
      Type:  defect        |      Status:  closed       
  Priority:  medium        |   Milestone:  PostGIS 1.4.3
 Component:  postgis       |     Version:  1.3.X        
Resolution:  wontfix       |    Keywords:               
---------------------------+------------------------------------------------

Comment(by robe):

 --slight correction - forgot a paren
 {{{
 SELECT gvt.* FROM
 (SELECT * FROM GeometryValueType WHERE ST_SRID(geometry) = 4326) AS gvt
   WHERE
    ST_Within(gvt.geometry,
  ST_GeomFromText('POLYGON((-100 0, 0 0, 0 100, -100 100, -100 0))', 4326)
 )
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/771#comment:3>
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.