SET
ERROR:  EXPLAIN is not allowed in a non-volatile function
CONTEXT:  SQL statement "EXPLAIN (VERBOSE, FORMAT TEXT) SELECT DISTINCT datoms1.e::TEXT, CASE datoms2.value_type_tag WHEN 0 THEN datoms2.v_ref::TEXT WHEN 1 THEN datoms2.v_bool::TEXT WHEN 2 THEN datoms2.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms2.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms2.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms2.v_text WHEN 8 THEN ':' || datoms2.v_keyword WHEN 10 THEN datoms2.v_uuid::TEXT WHEN 11 THEN encode(datoms2.v_bytes, 'hex') ELSE NULL::TEXT END, CASE datoms3.value_type_tag WHEN 0 THEN datoms3.v_ref::TEXT WHEN 1 THEN datoms3.v_bool::TEXT WHEN 2 THEN datoms3.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms3.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms3.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms3.v_text WHEN 8 THEN ':' || datoms3.v_keyword WHEN 10 THEN datoms3.v_uuid::TEXT WHEN 11 THEN encode(datoms3.v_bytes, 'hex') ELSE NULL::TEXT END FROM (SELECT e, a, 7::SMALLINT AS value_type_tag, NULL::BIGINT AS v_ref, NULL::BOOLEAN AS v_bool, NULL::BIGINT AS v_long, NULL::DOUBLE PRECISION AS v_double, v AS v_text, NULL::TEXT AS v_keyword, NULL::TIMESTAMPTZ AS v_instant, NULL::UUID AS v_uuid, NULL::BYTEA AS v_bytes, tx, true AS added FROM mentat.current_text WHERE store_id = $1) AS datoms0, (SELECT e, a, 0::SMALLINT AS value_type_tag, v AS v_ref, NULL::BOOLEAN AS v_bool, NULL::BIGINT AS v_long, NULL::DOUBLE PRECISION AS v_double, NULL::TEXT AS v_text, NULL::TEXT AS v_keyword, NULL::TIMESTAMPTZ AS v_instant, NULL::UUID AS v_uuid, NULL::BYTEA AS v_bytes, tx, true AS added FROM mentat.current_ref WHERE store_id = $1) AS datoms1, (SELECT e, a, 7::SMALLINT AS value_type_tag, NULL::BIGINT AS v_ref, NULL::BOOLEAN AS v_bool, NULL::BIGINT AS v_long, NULL::DOUBLE PRECISION AS v_double, v AS v_text, NULL::TEXT AS v_keyword, NULL::TIMESTAMPTZ AS v_instant, NULL::UUID AS v_uuid, NULL::BYTEA AS v_bytes, tx, true AS added FROM mentat.current_text WHERE store_id = $1) AS datoms2, (SELECT e, a, 8::SMALLINT AS value_type_tag, NULL::BIGINT AS v_ref, NULL::BOOLEAN AS v_bool, NULL::BIGINT AS v_long, NULL::DOUBLE PRECISION AS v_double, NULL::TEXT AS v_text, v AS v_keyword, NULL::TIMESTAMPTZ AS v_instant, NULL::UUID AS v_uuid, NULL::BYTEA AS v_bytes, tx, true AS added FROM mentat.current_keyword WHERE store_id = $1) AS datoms3 WHERE datoms0.a = (SELECT entid FROM mentat.schema WHERE ident = $2) AND (datoms0.v_text = $3 AND datoms0.value_type_tag = 7) AND datoms0.added = true AND datoms1.a = (SELECT entid FROM mentat.schema WHERE ident = $4) AND datoms1.v_ref = datoms0.e AND datoms1.added = true AND datoms2.e = datoms1.e AND datoms2.a = (SELECT entid FROM mentat.schema WHERE ident = $5) AND datoms2.added = true AND datoms3.e = datoms1.e AND datoms3.a = (SELECT entid FROM mentat.schema WHERE ident = $6) AND datoms3.added = true"
