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

     1  // Code generated by TestPretty. DO NOT EDIT.
     2  // GENERATED FILE DO NOT EDIT
     3  1:
     4  -
     5    SELECT NULL AS table_cat,
     6           n.nspname AS table_schem,
     7           ct.relname AS table_name,
     8           NOT
     9  			i.indisunique AS non_unique,
    10           NULL AS index_qualifier,
    11           ci.relname AS index_name,
    12           CASE i.indisclustered
    13           WHEN true THEN 1
    14           ELSE CASE am.amname
    15           WHEN 'hash' THEN 2
    16           ELSE 3
    17           END
    18           END AS type,
    19           (i.keys).n AS ordinal_position,
    20           btrim(
    21  			pg_catalog.pg_get_indexdef(
    22  				ci.oid,
    23  				(i.keys).n,
    24  				false
    25  			),
    26  			'"'
    27           ) AS column_name,
    28           CASE am.amcanorder
    29           WHEN true
    30           THEN CASE i.indoption[(i.keys).n - 1]
    31           & 1
    32           WHEN 1 THEN 'D'
    33           ELSE 'A'
    34           END
    35           ELSE NULL
    36           END AS asc_or_desc,
    37           ci.reltuples AS cardinality,
    38           ci.relpages AS pages,
    39           pg_catalog.pg_get_expr(
    40  			i.indpred,
    41  			i.indrelid
    42           ) AS filter_condition
    43      FROM pg_catalog.pg_class AS ct
    44      JOIN pg_catalog.pg_namespace AS n ON
    45  			ct.relnamespace = n.oid
    46      JOIN (
    47  			SELECT i.indexrelid,
    48  			       i.indrelid,
    49  			       i.indoption,
    50  			       i.indisunique,
    51  			       i.indisclustered,
    52  			       i.indpred,
    53  			       i.indexprs,
    54  			       information_schema._pg_expandarray(
    55  					i.indkey
    56  			       )
    57  					AS keys
    58  			  FROM pg_catalog.pg_index
    59  					AS i
    60           ) AS i ON ct.oid = i.indrelid
    61      JOIN pg_catalog.pg_class AS ci ON
    62  			ci.oid = i.indexrelid
    63      JOIN pg_catalog.pg_am AS am ON
    64  			ci.relam = am.oid
    65     WHERE true
    66       AND n.nspname = 'public'
    67       AND ct.relname = 'j'
    68  ORDER BY non_unique,
    69           type,
    70           index_name,
    71           ordinal_position
    72  
    73