Public.getpercentavailabilityinwindow (function) - Revision history

Bot at 09:19, 27 August 2011

2011-08-27T09:19:36Z

Bot at 22:38, 24 June 2010

2010-06-24T22:38:55Z

Bot at 07:37, 11 February 2010

2010-02-11T07:37:55Z

Bot at 07:31, 11 February 2010

2010-02-11T07:31:49Z

Bot at 13:52, 7 August 2009

2009-08-07T13:52:47Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''function | public.getpercentavailabilityinwindow |- |}

 CREATE OR REPLACE FUNCTI...

2009-08-07T13:16:01Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''function | public.getpercentavailabilityinwindow |- |} <pre> CREATE OR REPLACE FUNCTI...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''function
| public.getpercentavailabilityinwindow
|-
|}

<pre>
CREATE OR REPLACE FUNCTION public.getpercentavailabilityinwindow(integer, character varying, integer, timestamp without time zone, timestamp without time zone)
RETURNS double precision
LANGUAGE plpgsql
AS $function$
DECLARE
nid ALIAS FOR $1;
ipid ALIAS FOR $2;
sid ALIAS FOR $3;
xtime ALIAS FOR $4;
ytime ALIAS FOR $5;
downtime float8;
BEGIN
downtime := getOutageTimeInWindow(nid, ipid, sid, xtime, ytime);
IF xtime > ytime THEN
RETURN 100 * (1 - (downtime / (EXTRACT(EPOCH FROM (xtime - ytime))* 1000)));
ELSE
RETURN 100 * (1 - (downtime / (EXTRACT(EPOCH FROM (ytime - xtime))* 1000)));
END IF;
END;
$function$
</pre>

← Older revision		Revision as of 09:19, 27 August 2011
Line 30:		Line 30:
	$function$		$function$
	</pre>		</pre>
−
−	~~=== References ===~~
−	~~{\| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"~~
−	~~\|- style="background:silver"~~
−	~~\| '''Dependency Type~~
−	~~\| '''Object Type~~
−	~~\| '''Referenced Object~~
−
−	~~\|- valign="top"~~
−	~~\| Execute~~
−	~~\| Function~~
−	~~\| [[public.getoutagetimeinwindow_(function)\|public.getoutagetimeinwindow]]~~
−
−	\|}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Function
 | public.getpercentavailabilityinwindow
 |}
 === Source ===
@@ Line 40: / Line 38: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Execute
 | Function

@@ Line 1: / Line 1: @@
 == wikibot ==
 CREATE OR REPLACE FUNCTION public.getpercentavailabilityinwindow(integer, character varying, integer, timestamp without time zone, timestamp without time zone)
   RETURNS double precision
@@ Line 20: / Line 31: @@
     END;
 $function$
 |-
 | Execute
 | Function
 | [[public.getoutagetimeinwindow_(function)|public.getoutagetimeinwindow]]

@@ Line 7: / Line 7: @@
 |-
 |}
 <pre>