[postgis-devel] Cast GeoJSON to geometry like with WKT

[Paul Ramsey]

Wait, what? what is in 'value'?

> On Mar 30, 2020, at 8:56 AM, rmrodriguez at carto.com wrote:
> 
> I've been bitten by this today. This code used to work in Postgis 2.x:
> ```
> SELECT (data->0->>'value')::Geometry
> ```
> But it now requires to be called as:
> ```
> ST_GeomFromGeoJSON(data->0->>'value')
> ```
> 
> So I wouldn't be opposed to backporting this to 3.0 if it were to be
> implemented.
> 
> -- 
> Raúl Marín Rodríguez
> carto.com
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-devel