github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/join1.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::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 = con.confkey[pos.n]
    56       AND con.confrelid = pkc.oid
    57       AND fkn.oid = fkc.relnamespace
    58       AND fkc.oid = fka.attrelid
    59       AND fka.attnum = con.conkey[pos.n]
    60       AND con.conrelid = fkc.oid
    61       AND con.contype = 'f'
    62       AND con.oid = dep.objid
    63       AND pkic.oid = dep.refobjid
    64       AND pkic.relkind = 'i'
    65       AND dep.classid
    66           = 'pg_constraint'::REGCLASS::OID
    67       AND dep.refclassid
    68           = 'pg_class'::REGCLASS::OID
    69       AND fkn.nspname = 'public'
    70       AND fkc.relname = 'orders'
    71  ORDER BY pkn.nspname,
    72           pkc.relname,
    73           con.conname,
    74           pos.n
    75  
    76