version functions for PostGRES 7-3
aug, 2008
problem:
Extra version functions for PostGRES 7.3
solution:
CREATE OR REPLACE FUNCTION version_major() RETURNS "numeric" AS 'select substring(version() from \'PostgreSQL ([0-9]+.[0-9]+)\')::numeric(6, 1)' LANGUAGE 'sql' IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION version_minor() RETURNS int4 AS 'select substring(version() from \'PostgreSQL [0-9]+\\\\.[0-9]+\\\\.([0-9]+)\')::integer' LANGUAGE 'sql' IMMUTABLE STRICT;