Public.getmanagedservicecountfornode (function)

From dbscript Online Help
Revision as of 08:37, 11 February 2010 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

Function public.getmanagedservicecountfornode


Source

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$

References

Dependency Type Object Type Referenced Object
Select Table public.ifservices
Select Table public.ipinterface

Dependencies

Reference Type Object Type Referencing Object
Execute Function public.getmanagepercentavailnodewindow