[postgis-devel] How define a view that use a case operator for geometry field

[Sandro Santilli]

On Fri, Oct 28, 2011 at 06:48:10PM +0200, aperi2007 wrote:

> 	case
> 		when a.codlinea<>'' then b.geom::geometry(LINESTRING,3003)
> 		when a.codlineasoprasotto<>'' then c.geom::geometry(LINESTRING,3003)
> 	end as geom

ELSE ?

> Is correct that geometry_columns don't report the geometry-type and
> the srid of a view defined like this ?

Try:

 SELECT * FROM the_view WHERE ST_SRID(geom) = 0;

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html