--
-- acs_util__has_children/3
--
create or replace function acs_util__has_children(
  character varying,
  character varying,
  character varying
) returns bool as $$

declare
  item_id_in		alias for $1;
  table_name_in		alias for $2;
  parent_column_in	alias for $3;
  v_row_count		integer;
begin
  execute 'select 1 where exists (select 1 from '
	    || quote_ident(table_name_in)
	    || ' where '
	    || quote_ident(parent_column_in)
	    || ' = '
	    || quote_literal(item_id_in)
	    || ')';
  get diagnostics v_row_count = ROW_COUNT;
  if v_row_count = 1 then
     return 't';
  else
     return 'f';
  end if;
end;$$ language plpgsql;