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