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

Paragon Corporation lr at pcorp.us
Sat Oct 29 14:53:40 PDT 2011

> 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
> ...

		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)

More information about the postgis-devel mailing list