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

     1  // Code generated by TestPretty. DO NOT EDIT.
     2  // GENERATED FILE DO NOT EDIT
     3  1:
     4  -
     5  SELECT
     6  	NULL::STRING AS pktable_cat,
     7  	pkn.nspname AS pktable_schem,
     8  	pkc.relname AS pktable_name,
     9  	pka.attname AS pkcolumn_name,
    10  	NULL::STRING AS fktable_cat,
    11  	fkn.nspname AS fktable_schem,
    12  	fkc.relname AS fktable_name,
    13  	fka.attname AS fkcolumn_name,
    14  	pos.n AS key_seq,
    15  	CASE con.confupdtype
    16  	WHEN 'c' THEN 0
    17  	WHEN 'n' THEN 2
    18  	WHEN 'd' THEN 4
    19  	WHEN 'r' THEN 1
    20  	WHEN 'a' THEN 3
    21  	ELSE NULL
    22  	END
    23  		AS update_rule,
    24  	CASE con.confdeltype
    25  	WHEN 'c' THEN 0
    26  	WHEN 'n' THEN 2
    27  	WHEN 'd' THEN 4
    28  	WHEN 'r' THEN 1
    29  	WHEN 'a' THEN 3
    30  	ELSE NULL
    31  	END
    32  		AS delete_rule,
    33  	con.conname AS fk_name,
    34  	pkic.relname AS pk_name,
    35  	CASE
    36  	WHEN con.condeferrable
    37  	AND con.condeferred
    38  	THEN 5
    39  	WHEN con.condeferrable THEN 6
    40  	ELSE 7
    41  	END
    42  		AS deferrability
    43  FROM
    44  	pg_catalog.pg_namespace AS pkn,
    45  	pg_catalog.pg_class AS pkc,
    46  	pg_catalog.pg_attribute AS pka,
    47  	pg_catalog.pg_namespace AS fkn,
    48  	pg_catalog.pg_class AS fkc,
    49  	pg_catalog.pg_attribute AS fka,
    50  	pg_catalog.pg_constraint AS con,
    51  	pg_catalog.generate_series(1, 32)
    52  		AS pos (n),
    53  	pg_catalog.pg_depend AS dep,
    54  	pg_catalog.pg_class AS pkic
    55  WHERE
    56  	pkn.oid = pkc.relnamespace
    57  	AND pkc.oid = pka.attrelid
    58  	AND pka.attnum = con.confkey[pos.n]
    59  	AND con.confrelid = pkc.oid
    60  	AND fkn.oid = fkc.relnamespace
    61  	AND fkc.oid = fka.attrelid
    62  	AND fka.attnum = con.conkey[pos.n]
    63  	AND con.conrelid = fkc.oid
    64  	AND con.contype = 'f'
    65  	AND con.oid = dep.objid
    66  	AND pkic.oid = dep.refobjid
    67  	AND pkic.relkind = 'i'
    68  	AND dep.classid
    69  		= 'pg_constraint'::REGCLASS::OID
    70  	AND dep.refclassid
    71  		= 'pg_class'::REGCLASS::OID
    72  	AND fkn.nspname = 'public'
    73  	AND fkc.relname = 'orders'
    74  ORDER BY
    75  	pkn.nspname,
    76  	pkc.relname,
    77  	con.conname,
    78  	pos.n
    79  
    80