register
[username]

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;

tags:

PostGRES; 7-3; version