--
-- site_node__delete/1
--
create or replace function site_node__delete(
  integer
) returns int4 as $$

declare
  delete__node_id                alias for $1;  
begin
    delete from site_nodes
    where node_id = delete__node_id;

    PERFORM acs_object__delete(delete__node_id);

    return 0; 
end;$$ language plpgsql;