[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