github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/join3.sql (about)

     1  SELECT NULL AS table_cat,
     2         n.nspname AS table_schem,
     3         ct.relname AS TABLE_NAME,
     4         NOT i.indisunique AS non_unique,
     5         NULL AS index_qualifier,
     6         ci.relname AS index_name,
     7         CASE i.indisclustered
     8           WHEN TRUE THEN 1
     9           ELSE CASE am.amname
    10             WHEN 'hash' THEN 2
    11             ELSE 3
    12           END
    13         END AS TYPE,
    14         (i.KEYS).n AS ordinal_position,
    15         trim(BOTH '"' FROM pg_catalog.pg_get_indexdef(ci.oid, (i.KEYS).n, FALSE)) AS COLUMN_NAME,
    16         CASE am.amcanorder
    17           WHEN TRUE THEN CASE i.indoption[(i.keys).n - 1] & 1
    18             WHEN 1 THEN 'D'
    19             ELSE 'A'
    20           END
    21           ELSE NULL
    22         END AS asc_or_desc,
    23         ci.reltuples AS CARDINALITY,
    24         ci.relpages AS pages,
    25         pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition
    26  FROM pg_catalog.pg_class ct
    27  JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid)
    28  JOIN (
    29    SELECT i.indexrelid,
    30           i.indrelid,
    31           i.indoption,
    32           i.indisunique,
    33           i.indisclustered,
    34           i.indpred,
    35           i.indexprs,
    36           information_schema._pg_expandarray(i.indkey) AS KEYS
    37    FROM pg_catalog.pg_index i
    38  ) i
    39    ON (ct.oid = i.indrelid)
    40  JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid)
    41  JOIN pg_catalog.pg_am am ON (ci.relam = am.oid)
    42  WHERE TRUE
    43    AND n.nspname = 'public'
    44    AND ct.relname = 'j'
    45  ORDER BY non_unique,
    46           TYPE,
    47           index_name,
    48           ordinal_position