-- -- 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;