• Home
• it.cnr.si.sigla
• sigla-backend
• 6.6.4
• source code
• ibmutl001_getdbrefreshdate.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

postgresql.function.ibmutl001_getdbrefreshdate.sql Maven / Gradle / Ivy

-- Function: public.ibmutl001_getdbrefreshdate()

-- DROP FUNCTION public.ibmutl001_getdbrefreshdate();

CREATE OR REPLACE FUNCTION ibmutl001_getdbrefreshdate()
  RETURNS timestamp without time zone AS
$BODY$
DECLARE

  DateRefresh  timestamp;

BEGIN
  SELECT (pg_stat_file('base/'||oid ||'/PG_VERSION')).modification  into DateRefresh FROM pg_database
  where datname = current_database();
   Return DateRefresh;
Exception
  When Others Then
    Return clock_timestamp();
END;

$BODY$
  LANGUAGE plpgsql VOLATILE SECURITY DEFINER
  COST 100;