1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
|
select
cast(nullif(sample_0.refobjsubid,
(select pg_catalog.bit_xor(pid) from pg_catalog.pg_stat_progress_vacuum)
) as int4) as c0,
sample_0.deptype as c1,
sample_0.classid as c2,
pg_catalog.poly_overabove(
cast(cast(coalesce(cast(null as polygon),
case when (cast(null as circle) < cast(null as circle))
or (subq_0.c7 is not NULL) then pg_catalog.polygon(
cast(case when false then cast(null as box) else cast(null as box) end
as box)) else pg_catalog.polygon(
cast(case when false then cast(null as box) else cast(null as box) end
as box)) end
) as polygon) as polygon),
cast(case when subq_0.c6 is NULL then case when (sample_0.classid is NULL)
or (cast(null as box) << cast(null as box)) then case when true then cast(nullif(cast(null as polygon),
cast(null as polygon)) as polygon) else cast(nullif(cast(null as polygon),
cast(null as polygon)) as polygon) end
else case when true then cast(nullif(cast(null as polygon),
cast(null as polygon)) as polygon) else cast(nullif(cast(null as polygon),
cast(null as polygon)) as polygon) end
end
else case when (sample_0.classid is NULL)
or (cast(null as box) << cast(null as box)) then case when true then cast(nullif(cast(null as polygon),
cast(null as polygon)) as polygon) else cast(nullif(cast(null as polygon),
cast(null as polygon)) as polygon) end
else case when true then cast(nullif(cast(null as polygon),
cast(null as polygon)) as polygon) else cast(nullif(cast(null as polygon),
cast(null as polygon)) as polygon) end
end
end
as polygon)) as c3,
pg_catalog.pg_is_wal_replay_paused() as c4,
subq_0.c6 as c5,
sample_0.objsubid as c6,
subq_0.c0 as c7
from
(select
ref_0.is_implicitly_invocable as c0,
ref_0.routine_body as c1,
ref_0.result_cast_type_udt_name as c2,
ref_0.sql_data_access as c3,
ref_0.result_cast_char_set_name as c4,
ref_0.numeric_precision as c5,
ref_0.udt_schema as c6,
ref_0.datetime_precision as c7,
ref_0.routine_catalog as c8,
ref_0.type_udt_catalog as c9,
ref_0.security_type as c10
from
information_schema.routines as ref_0
where (cast(null as name) = cast(null as name))
and (cast(null as float8) >= (select wal_write_time from pg_catalog.pg_stat_wal limit 1 offset 6)
)
limit 71) as subq_0
inner join pg_catalog.pg_depend as sample_0 tablesample bernoulli (6.4)
on ((select safe_wal_size from pg_catalog.pg_replication_slots limit 1 offset 1)
<= cast(null as int2))
where pg_catalog.close_pl(
cast(pg_catalog.lseg_center(
cast(cast(null as lseg) as lseg)) as point),
cast(case when (subq_0.c0 is NULL)
and (pg_catalog.path_mul_pt(
cast(cast(null as path) as path),
cast(cast(null as point) as point)) @> cast(null as point)) then cast(null as line) else cast(null as line) end
as line)) |>> pg_catalog.poly_center(
cast(cast(coalesce(case when 44 is not NULL then cast(null as polygon) else cast(null as polygon) end
,
case when (select adnum from pg_catalog.pg_attrdef limit 1 offset 79)
<= sample_0.refobjsubid then cast(coalesce(cast(null as polygon),
cast(null as polygon)) as polygon) else cast(coalesce(cast(null as polygon),
cast(null as polygon)) as polygon) end
) as polygon) as polygon))
|
