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

[Paragon Corporation]

> declaring the view using the bad code:
> 
> ...
> 	case
> 		when a.codlinea<>'' then 
> b.geom::geometry(LINESTRING,3003)
> 		when a.codlineasoprasotto<>'' then 
> c.geom::geometry(LINESTRING,3003)
> 	end as geom
> ...
> 

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


I think that is what I do when I say want ot case result to varchar(50)