uranux_desenv [uranux.xml] |
Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
URX_PUBLIC._postgis_pgsql_version() | (Procedure) |
Name | URX_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; |