Difference between revisions of "Public.getmanagedservicecountfornode (function)"

From dbscript Online Help
Jump to: navigation, search
Line 1: Line 1:
 
== wikibot ==
 
== wikibot ==
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|-
 
| '''function
 
| public.getmanagedservicecountfornode
 
|-
 
|}
 
 
 
<pre>
 
 
CREATE OR REPLACE FUNCTION public.getmanagedservicecountfornode(integer)
 
CREATE OR REPLACE FUNCTION public.getmanagedservicecountfornode(integer)
 
  RETURNS double precision
 
  RETURNS double precision
Line 35: Line 25:
 
   END;
 
   END;
 
$function$
 
$function$
</pre>
+
|-
 +
| Select
 +
| Table
 +
| [[public.ifservices_(table)|public.ifservices]]
 +
 
 +
|-
 +
| Select
 +
| Table
 +
| [[public.ipinterface_(table)|public.ipinterface]]
 +
 
 +
|-
 +
| Execute
 +
| Function
 +
| [[public.getmanagepercentavailnodewindow_(function)|public.getmanagepercentavailnodewindow]]

Revision as of 08:31, 11 February 2010

wikibot

CREATE OR REPLACE FUNCTION public.getmanagedservicecountfornode(integer)

RETURNS double precision
LANGUAGE plpgsql

AS $function$

  DECLARE
       nid ALIAS FOR $1;
       orec RECORD;
       counter float8;
  BEGIN
       counter = 0;
        FOR orec IN SELECT distinct ifservices.nodeid, ifservices.serviceid, ifservices.ipaddr
               FROM ipinterface, ifservices
               WHERE ifservices.nodeid = nid
                       AND ipinterface.nodeid = nid
                       AND ipinterface.ismanaged = 'M'
                       AND ifservices.ipaddr = ipinterface.ipaddr
                       AND ifservices.status = 'A'
       LOOP
               BEGIN
                        counter := counter + 1;
               END;
       END LOOP;
       RETURN counter;
  END;

$function$ |- | Select | Table | public.ifservices

|- | Select | Table | public.ipinterface

|- | Execute | Function | public.getmanagepercentavailnodewindow