[postgis-tickets] r16416 - jsonb type is only available since PostgreSQL 9.4.0

Sandro Santilli strk at kbt.io
Sat Feb 24 08:21:39 PST 2018


Author: strk
Date: 2018-02-24 08:21:38 -0800 (Sat, 24 Feb 2018)
New Revision: 16416

Modified:
   trunk/postgis/postgis.sql.in
Log:
jsonb type is only available since PostgreSQL 9.4.0

Closes #4028 (thanks Dronie for finding out)

Modified: trunk/postgis/postgis.sql.in
===================================================================
--- trunk/postgis/postgis.sql.in	2018-02-23 21:54:22 UTC (rev 16415)
+++ trunk/postgis/postgis.sql.in	2018-02-24 16:21:38 UTC (rev 16416)
@@ -4310,11 +4310,13 @@
         AS 'SELECT @extschema at .ST_GeomFromGeoJson($1::text)'
         LANGUAGE 'sql' IMMUTABLE STRICT _PARALLEL;
 
+#if POSTGIS_PGSQL_VERSION >= 94
 -- Availability: 2.5.0
 CREATE OR REPLACE FUNCTION ST_GeomFromGeoJson(jsonb)
         RETURNS geometry
         AS 'SELECT @extschema at .ST_GeomFromGeoJson($1::text)'
         LANGUAGE 'sql' IMMUTABLE STRICT _PARALLEL;
+#endif
 
 -- Availability: 2.0.0
 CREATE OR REPLACE FUNCTION postgis_libjson_version()



More information about the postgis-tickets mailing list