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

Sandro Santilli strk at keybit.net
Sun Oct 30 01:13:29 PDT 2011


On Sat, Oct 29, 2011 at 05:53:40PM -0400, Paragon Corporation wrote:

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

Neat ! 

--strk; 

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



More information about the postgis-devel mailing list