 
 CREATE OR REPLACE FUNCTION get_descendant_asn_ids(standard_asn_id CHAR(8))
   RETURNS bpchar[] AS $$
+
   WITH RECURSIVE tree AS (
     SELECT
       asn_id,

AND ARRAY ['S11436A8', 'S11436A6', 'S11436A9', 'S11438D0', 'S1143938', 'S114372C', 'S11437EB', 'S114372B', 'S11436A5', 'S11437E9']::char[]
      @> ancestors;*/

CREATE OR REPLACE FUNCTION get_descendant_standard_nodes(standard_asn_id CHAR(8))
  RETURNS SETOF standards_nodes AS $$
  WITH RECURSIVE tree AS (
    SELECT


CREATE OR REPLACE FUNCTION get_ancestor_asn_ids(standard_asn_id CHAR(8))
  RETURNS bpchar[] AS $$

   WITH RECURSIVE tree AS (
    SELECT
      asn_id,
