[postgis-devel] JSON Fn Name

Sandro Santilli strk at kbt.io
Fri Apr 19 03:42:12 PDT 2019


On Thu, Apr 18, 2019 at 12:06:07PM -0700, Paul Ramsey wrote:
> Quick temperature-of-the-room
> 
> ST_AsGeoJSON(record)
> 
> or
> 
> row_to_geojson(record)
> 
> The latter apes the existing pgsql json pattern row_to_json().

I'd like if the pgsql json converter would allow specifying
"canonical forms", like it is for TEXT and BINARY (text and bitea
outputs).

Is there any chance such a thing exists or we can at least suggest
it upstream ? If that was possible, we'd just rely on `row_to_json`
and that function would do the right thing when facing geometries,
does that sound possible in theory or am I missing some specific
characteristics of a "geojson" ?

--strk;


More information about the postgis-devel mailing list