URX_PUBLIC._postgis_pgsql_version() - Procedure
Home|Tables|Schemas|Diagrams|Foreign Keys|Indexes

NameURX_PUBLIC._postgis_pgsql_version()
Comment
Src
CREATE FUNCTION "URX_PUBLIC"."_postgis_pgsql_version"() 
 RETURNS text AS 
$BODY$
	SELECT CASE WHEN split_part(s,'.',1)::integer > 9 THEN split_part(s,'.',1) || '0' ELSE split_part(s,'.', 1) || split_part(s,'.', 2) END AS v
	FROM substring(version(), 'PostgreSQL ([0-9\.]+)') AS s;
$BODY$
 LANGUAGE 'sql' STABLE;