ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
public.getmanagedservicecountforintf_(function)
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Function''' | public.getmanagedservicecountforintf |} === Source === {{{{<nowiki> CREATE OR REPLACE FUNCTION public.getmanagedservicecountforintf(integer, character varying) RETURNS double precision LANGUAGE plpgsql AS $function$ DECLARE nid ALIAS FOR $1; ipid ALIAS FOR $2; orec RECORD; counter float8; BEGIN counter = 0; FOR orec IN SELECT DISTINCT ifservices.nodeid, ifservices.ipaddr, ifservices.serviceid FROM ipinterface, ifservices WHERE ifservices.nodeid = nid AND ifservices.ipaddr = ipid AND ipinterface.nodeid = nid AND ipinterface.ipaddr = ipid AND ipinterface.ismanaged = 'M' AND ifservices.status = 'A' LOOP BEGIN counter := counter + 1; END; END LOOP; RETURN counter; END; $function$ </nowiki>}}}}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.