| 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; |