[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
> ...
>
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)
More information about the postgis-devel
mailing list