github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/join3.align-only.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
    45  				AS n ON ct.relnamespace
    46  			        = n.oid
    47           JOIN (
    48  				SELECT i.indexrelid,
    49  				       i.indrelid,
    50  				       i.indoption,
    51  				       i.indisunique,
    52  				       i.indisclustered,
    53  				       i.indpred,
    54  				       i.indexprs,
    55  				       information_schema._pg_expandarray(
    56  						i.indkey
    57  				       )
    58  						AS keys
    59  				  FROM pg_catalog.pg_index
    60  						AS i
    61  			) AS i ON ct.oid
    62  			          = i.indrelid
    63           JOIN pg_catalog.pg_class
    64  				AS ci ON ci.oid
    65  			         = i.indexrelid
    66           JOIN pg_catalog.pg_am AS am ON
    67  				ci.relam = am.oid
    68     WHERE true
    69           AND n.nspname = 'public'
    70           AND ct.relname = 'j'
    71  ORDER BY non_unique,
    72           type,
    73           index_name,
    74           ordinal_position
    75  
    76