Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
CREATE OR REPLACE FUNCTION public.ft_val ( sp integer = (-1), rad integer = 0, cp text = ''::text ) RETURNS TABLE ( geom public.geometry, no text, ptype char ) AS $body$ BEGIN RETURN QUERY SELECT geometry AS geom, '' AS no, 'S' AS ptype FROM drwg WHERE id = sp UNION SELECT st_buffer(st_centroid(geometry), rad, 64), '', 'R' FROM drwg WHERE id = sp END; $body$ LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER COST 100 ROWS 20;
DECLARE cps integer := string_to_array(cp, ',')::INT;
UNION FOREACH i IN ARRAY cps LOOP SELECT geometry AS geom, i, 'C' FROM drwg WHERE id = cps[i] END LOOP
Join the community of 500,000 technology professionals and ask your questions.