SELECT CASE datoms0.value_type_tag WHEN 0 THEN datoms0.v_ref::TEXT WHEN 1 THEN datoms0.v_bool::TEXT WHEN 2 THEN datoms0.v_long::TEXT WHEN 3 THEN 'd:' || ('x' || encode(float8send(datoms0.v_double), 'hex'))::bit(64)::bigint::TEXT WHEN 4 THEN to_char(datoms0.v_instant AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS.US"Z"') WHEN 7 THEN datoms0.v_text WHEN 8 THEN ':' || datoms0.v_keyword WHEN 10 THEN datoms0.v_uuid::TEXT WHEN 11 THEN encode(datoms0.v_bytes, 'hex') ELSE NULL::TEXT END, COUNT(*)::TEXT FROM (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 datoms0 WHERE datoms0.a = (SELECT entid FROM mentat.schema WHERE ident = $2) AND datoms0.added = true GROUP BY datoms0.value_type_tag, datoms0.v_ref, datoms0.v_bool, datoms0.v_long, datoms0.v_double, datoms0.v_text, datoms0.v_keyword, datoms0.v_instant, datoms0.v_uuid, datoms0.v_bytes
